Kbase 21527: How and Where to modify the DSN settings in the registry
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
How to register additional strings for file DSN for ODBC.
GOAL:
How to register additional strings for system DSN for ODBC.
GOAL:
How to register additional strings for user DSN for ODBC.
GOAL:
How to modify the DSN settings in the registry
GOAL:
Where to modify the DSN settings in the registry
FACT(s) (Environment):
Windows 32 Intel
Windows NT 32 Intel/Windows 2000
Progress 8.x
Progress 9.x
FIX:
When the original configuration of the ODBC's DSN needs to be modified, it can be done via the registry.
The configuration file can also be used to edit the original configuration of the file DSN.
To edit the registry's DSN entries do the following:
-- For system DSN, go to following key in the registry:
HKEY_Current_User/Software/ODBC/ODBCINI
On the right panel, select the datasource to be modified and add a new string value.
For example, if it's workaround2=16, the following string value name is added:
"workarounds2" (no space is permitted)
and in the data field: "16".
-- For user DSN, modify the following key as above:
HKEY_Local_Machine/Software/ODBC/ODBCINI.
-- Options for file DSNs are set in the .dsn file. The .dsn files are saved by default in the C:\Program Files\Common Files\ODBC\Data Sources directory.
To verify the location of the .dsn file, go to the FileDSN tab of the Data Source Administrator and note the "Look in" directory.
Navigate to the appropriate directory and open the data source file with Notepad. then add the new options and save the changes.