Kbase P148588: Error 6142 connecting from system DSN on 64 bit windows machine
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/06/2009 |
|
Status: Unverified
SYMPTOM(s):
Error 6142 connecting from system DSN on 64 bit windows machine
Failed to connect to the MSS database. (6142)
IM002[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. Failed to connect to the MSS database. (6142)
FACT(s) (Environment):
Using 32 bit MSS DataServer product
64 bit Windows machine
ODBC Administrator is invoked from "Administrative tools", from %WINDIR%\system32 directory
Directly invoking ODBC Administrator from %WINDIR%\syswow64\odbcad32.exe directory gets the same error
x86_64 (AMD64/EMT64)
Windows Server 2003
OpenEdge 10.x
CAUSE:
The original problem was caused by not using 64 bit ODBC administrator. Since DataServer is a 32 bit product, it can not read data sources from 64 bit ODBC administrator.
After switching to 32 bit ODBC Administrator, the registration key HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI is missing "ODBC Data Sources" subkey, therefore, the 32 bit ODBC Administrator was not working, either
FIX:
1. Add following key
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\ODBC Data Sources]
to the registry
2. Invoke ODBC Administrator from %WINDIR%\syswow64\odbcad32.exe tool, or %SYSTEMROOT%\SysWOW64\odbcad32.exe