Kbase P112015: The ODBC Driver will not install on Windows 64 bit
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/11/2010 |
|
Status: Verified
SYMPTOM(s):
Progress ODBC drivers do not appear in the ODBC Data Sources Administration tool.
Progress ODBC drivers are not listed when trying to add a new ODBC Data Source.
No SQL-92 ODBC Driver showing in Microsoft DSN Administrator
32-bit Progress installed on Windows 64-bit is not showing in the Windows 64-bit ODBC manager.
The drivers do not show up in the DSN Administrator
The ODBC Driver will not install on Windows 64 bit
The setup routines for Progress OpenEdge 10.1x driver ODBC driver could not be loaded due to system error 193
The setup routines for Progress OpenEdge 10.2x driver ODBC driver could not be loaded due to system error 193
The setup routines for the DataDirect 4.20 32-BIT OpenEdge SQL v10.0B ODBC driver could not be loaded due to system error code 193.
Driver's ConfigDSN, ConfigDriver, or ConfigTranslator failed
Could not load the setup or translator library
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI is missing
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI does not show the ODBC Driver
ODBC Drivers are not being seen in the ODBC Data Source Administrator
FACT(s) (Environment):
No errors were detected during installation
%DLC%\installd.ini shows all JDBC and ODBC client options are set to 1
installd.ini shows all JDBC and ODBC client options set to 1
SQL Client Access product is installed.
Complete install was performed
Complete installation validated in %DLC%\install\response.ini
Progress 9.x
OpenEdge 10.x
Windows 64-bit
Windows 2003 x64
OpenEdge Category: Installation
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 the registry keys being added under:
HKLM\SOFTWARE\ODBC\ODBCINST.INI
HKLM\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers,
The registry keys are located 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.
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.