After adding the drivers into the system registry, it is now time to add a System Datasource entry. I open 'Data Srouce (ODBC)' in Control Panel as a sysadmin, select the System DSN table, click add , select the new DataDirect 5.3 DB2 Wire Protocal driver , click finish and I get a error message "The setup routines for the DataDirect 5.3 DB2 Wire Protocal ODBC driver could not be loaded due to system error code 126" then "could not load the setup or traslator library".
I hate system errors, especially on windows. googling around this time does not give my any hints, what should I do?
I know for a fact that System Data Source are stored in registry, maybe regedit can give me some idea. So I started regedit and search for "DataDirect 5.3", it find something for me like following:
Wait, those directories doesn't look right, I do remember that my ODBC drivers are installed in %OMNIHOME%\ODBC32v53, maybe I should change those PATH and see how it goes.
The problem get resolved after changing the PATH to following, I can finally add a DB2 datasource entry to the System DSN:
I can even do a test and it returned successfully.
Ok, the ODBC thing is now over, I can finally move to next step, configuring the gateway.
This seems to be a product bug in %OMNIHOME%\ODBC32v53\nco_install_drivers.exe.
Configuring ODBC gateway on windows- part 2 - Adding System Datasource