Question & Answer
Question
By default, 64 bit Windows versions use a 64 bit ODBC Administrator utility. How do I install a 32 bit version of ODBC to work with IBM Informix Dynamic Server, when I am using a 64 bit Windows version?
Cause
The menu option Administrative Tools->Data Sources (ODBC), is the Windows 7 utility used to maintain ODBC data sources and drivers. The path for this ODBC administrator utility is "%windir%\system32\odbcad32.exe". Although it is referenced as "32" in the path name, it is a 64 bit administration tool. The IBM Informix 32 bit ODBC option will not be visible when using this utility.
Answer
In order to use a 32 bit ODBC driver on a 64 bit Windows machine, it has to be configured using a 32 bit ODBC Administrator which is not visible through normal Windows menu options. Utilities for 32 bit operations are found in the C:\Windows\SysWOW64 directory. As a prerequisite for a 32 bit IBM Informix CSDK installation to proceed correctly, add the SysWOW64 directory to the system path, as follows:
- Run 'C:\Windows\System32\control.exe system'
- Select Advanced system settings from Control Panel Home
- On the System Properties Panel that appears,
- Select: Advanced tab->Environment Variables
- In the System Variables window under Environment Variables,
- Select and edit the PATH variable. Prefix the PATH list with 'C:\Windows\SysWOW64;'
Once the CSDK installation is completed, access the ODBC administrator utility located at 'C:\Windows\SysWOW64\odbcad32.exe'.
Now, when you access the Drivers Tab of the ODBC Administrator, the IBM Informix Driver is visible. This is the one you want to use.
At this point, you can proceed with normal configuration.
Related Information
Was this topic helpful?
Document Information
Modified date:
03 June 2021
UID
swg21616019