IBM Support

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

Troubleshooting


Problem

You receive the following system error code 193 when using the Microsoft ODBC Administrator to create the DataSource for Tivoli Netcool / OMNIbus on Windows 64-bit: The setup routines for the DataDirect 5.3 ODBC driver could not be loaded due to system error code 193.

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.

[{"Product":{"code":"SSSHTQ","label":"Tivoli Netcool\/OMNIbus"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"ODBC (MySQL) Gateway","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.4.0;7.3.1;7.3.0","Edition":"All Editions","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
17 June 2018

UID

swg21377507