Installing ODBC drivers

When you install Sybase IQ on a UNIX or Linux server, the installer also installs an ODBC driver, which can be directly accessed by applications. If you use an ODBC application that uses libodbc.so (libodbc.so.1) or libodbcinst.so (libodbcinst.so.1), create symbolic links to that point to $SYBASE/IQ-15_2/lib64/libdbodbc11.so.1 for single-threaded or $SYBASE/IQ-15_2/lib64/libdbodbc11_r.so.1 for multi-threaded applications. If you are creating an ODBC application, you can link directly to libdbodbc11.so for non–threaded applications and libdbodbc11_r.so for threaded applications. References to ODBC functions are resolved at run-time.

The filenames cited above have platform–specific suffixes. The so suffix shown is specific to the Sun Solaris system. For a list of ODBC driver files for supported UNIX platforms, see "Linking ODBC applications on Unix" in SQL Anywhere Server – Programming. Note that Sybase IQ does not support the Mac OS X platform.

32-bit and 64-bit drivers

UNIX 64-bit applications, including many third-party tools, can use 64-bit ODBC drivers to connect to 64-bit IQ servers.

32-bit applications can use 32-bit ODBC drivers to connect to 64-bit IQ servers. (32-bit applications cannot use 64-bit ODBC drivers to connect to 64-bit IQ servers.)

The Sybase IQ Network Client CD supplied with all platforms contains an ODBC driver for connecting from Windows-based ODBC applications.

To connect via ODBC from 32-bit UNIX client applications, download and install the 32-bit ODBC driver kit. Check the EBF/Update information for the appropriate driver.