Kbase P21008: How to set the default SQL-92 Schema on Windows for ODBC Connection ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/03/2008 |
|
Status: Verified
GOAL:
How to set the default SQL-92 Schema on Windows for ODBC Connection ?
GOAL:
How to avoid specifying the "PUB" schema in a SQL query
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
Windows NT 32 Intel/Windows 2000
FIX:
Edit the Windows registry and depending if you are using a User or System DSN, add the default schema from the following entry:
HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\<your DSN name>
or
HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI\<your DSN name>
For 64 bit Windows systems, you can find these keys under:
HKEY_CURRENT_USER\Software\Wow6432Node\ODBC\ODBCI.INI
or
HKEY_LOCAL_MACHINE\Software\Wow6432Node\ODBC\ODBCI.INI
To add the Default Schema (typically PUB if it is a 4GL Table):
- Select the DSN Name,
- In the right side of the Window, right-click
- Select "New"
- Select "String Value"
- Type "DefaultSchema"
- Enter
- Double-Click on the newly added entry "DefaultSchema"
- Enter the Default Schema (example : PUB)