Kbase P130514: Error 6142 when connecting to MS SQL Server on a Windows 64-bit machine
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/04/2008 |
|
Status: Unverified
FACT(s) (Environment):
Windows 64-bit
WebSpeed 3.x
OpenEdge 10.x
SYMPTOM(s):
Error 6142 when connecting to MS SQL Server from WebSpeed
Failed to connect to the <db-type> database. (6142)
Failed to connect to the MSS database. (6142)
The connection also fails when connecting from _progres client
IM002: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Failed to connect to the MSS database. (6142)
CAUSE:
The Data Source Name (DSN) has been created from the 64-Bit version of the ODBC Data Source Name which cannot be used by WebSpeed/OpenEdge 32-Bit client.
FIX:
Create the DSN in the legacy 32-bit version of the ODBC Data Source Administrator.
In order to launch it, execute %WINDIR%\syswow64\odbcad32.exe tool, or %SYSTEMROOT%\SysWOW64\odbcad32.exe.