ODBC driver could not be loaded due to system error code 193
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 <driver name> ODBC driver could not be loaded due to system error code 193.
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."
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.
More support for:
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: 16 October 2017