Kbase P132010: Error 6142 when connecting to MS SQL Server via the SQL Server DataServer on Windows 64 bit
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/06/2008 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.0B
OpenEdge 10.1x
Windows 64-bit
Progress 9.1E
Windows 64-bit
MS SQL 2000
MS SQL 2005
SYMPTOM(s):
Error 6142 when connecting to MS SQL Server via the SQL Server DataServer on Windows 64 bit
IM002: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Failed to connect to the <db-type> database. (6142)
Could not load the setup or translator library
Microsoft SQL Server installed is 32-bit not 64-bit
CAUSE:
When the 64-bit version of Windows is running, the Progress install properly registers all ODBC drivers - they are just in a different place on x64.
Instead of registry keys added under:
HKLM\SOFTWARE\ODBC\ODBCINST.INI
HKLM\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers,
they are added under:
HKLM\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI
HKLM\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\ODBC Drivers
When configuring the ODBC drivers from the usual executable:
%SystemRoot%\system32\odbcad32.exe or %WINDIR%\System32\odbcad32.exe
These drivers cannot be found as they are created on the 32-bit side of the x64 system. There are currently no 64-bit drivers available for Progress on Windows 64-bit.
FIX:
In order to configure the 32-bit DataDirect Driver, a different DSN Administrator executable needs to be run in order to configure the 32-bit ODBC Drivers.
Create a desktop icon pointing to the following location:
%WINDIR%\SysWow64\odbcad32.exe
This will start the ODBC Data Source Administrator and from here, you will now be able to configure the drivers provided with the license installed.