ODBC driver could not be loaded due to system error code 193
Unable to use the Microsoft ODBC Administrator to create the DataSource on Windows 64-bit.
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: 31 May 2016