Symptom

When setting up the Informix ODBC Datasource in the ODBC DataSource Administrator, the following error returned:

Microsoft ODBC Administrator
The setup routines for the IBM INFORMIX ODBC DRIVER could not be found.  Please reinstall the driver.

Environment

  • PowerBuilder
  • Microsoft ODBC
  • Informix

Cause

PowerBuilder is a 32-bit application and requires 32-bit database software. Compatibility issue between 32-bit and 64-bit.

Resolution

PowerBuilder is a 32-bit application and requires the 32-bit Informix ODBC driver.  When creating the ODBC DataSource, create a System DataSource and use the 32-bit version of the ODBC DataSource Administrator.  You can access it from PowerBuilder - > Database Profiles -> ODBC -> ODBC Administrator or the 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder.

0
0