Adding ODBC Data Source Names on 64-bit Windows Systems

On 64-bit Windows systems, SAP Sybase IQ installs a 32-bit ODBC driver. Use the ODBC Administrator to add a new ODBC data source name.

1. Click Start > Programs > Sybase > Sybase IQ 16.0 > ODBC Administrator 64 bit.
2. Run C:\WINDOWS\SysWOW64\odbcad32.exe.
   Do not launch the ODBC Administrator from the Control Panel or Run box. Attempts to add a DSN starting the ODBC Administrator incorrectly may returns these 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.