On 64-bit Windows systems, Sybase IQ installs a 32-bit ODBC driver. To add new Data Source Names, invoke the ODBC Administrator one of two ways:
Run Start > Programs > Sybase > Data Access > ODBC Data Source Administrator
Run C:\WINDOWS\SysWOW64\odbcad32.exe
Other methods of launching ODBC Administrator from the Control Panel or Run box do not return desired results. If you type “odbcad32” instead of the full path in the Run text box, ODBC lists only one driver (SQL Server driver) and prevents adding Data Source Names. The Version or Company column in the driver list may include the value “(Not Marked).”
Attempts to add a DSN starting the ODBC Administrator incorrectly may return one of the following errors:
The
setup routines for the Adaptive Server IQ ODBC
driver could not be loaded due to system error code 126.
Driver’s ConfigDSN,
ConfigDriver, or ConfigTranslator
failed: Could not load the setup or translator library.
The setup routines for the Adaptive
Server IQ ODBC
driver could not be found. Please reinstall the driver.
