IBM Support

ODBC driver could not be loaded due to system error code 193

Technote (troubleshooting)


Problem(Abstract)

Unable to use the Microsoft ODBC Administrator to create the DataSource on Windows 64-bit.

Symptom

Receive the error

"The setup routines for the DataDirect 5.3 <driver name> ODBC driver could not be loaded due to system error code 193."


Cause

The driver is a 32-bit driver and the default Microsoft ODBC Administrator utility is for 64-bit drivers.


Resolving the problem

On 64-bit Windows, there are two versions of the Microsoft ODBC Administrator tool. Typically, you go to Start --> Administrative Tools --> Data Sources (ODBC) to create ODBC connections. This calls the program %WINDIR%\System32\odbcad32.exe to create a 64-bit ODBC connection. However, this program will not create 32-bit ODBC connections.

The ODBC gateway requires a 32-bit ODBC connection. Use the 32-bit version of the Microsoft ODBC Administrator tool located in %systemdrive%\Windows\SysWoW64\odbcad32.exe to create the ODBC Data Source.

Document information

More support for: Tivoli Netcool/OMNIbus
ODBC (MySQL) Gateway

Software version: 7.3.0, 7.3.1, 7.4.0

Operating system(s): Windows

Software edition: All Editions

Reference #: 1377507

Modified date: 31 May 2016