Installing ODBC drivers

When you install Sybase IQ on your UNIX or Linux server, the installation procedure also installs the ODBC driver, which can be directly accessed by applications. If you are using an ODBC application that uses libodbc.so (libodbc.so.1) or libodbcinst.so (libodbcinst.so.1), simply create symbolic links to that point to $SYBASE/IQ-15_0/lib/libdbodbc11.so.1 for single threaded or $SYBASE/IQ-15_0/lib/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.

NoteThe filenames cited above have platform–specific suffixes. The so suffix shown is specific to the Sun Solaris system. See “Linking ODBC applications on UNIX” in Chapter 7 of the SQL Anywhere Server Programming Guide for a list of files included in the driver managers for supported UNIX platforms.

The ODBC Driver shipped with Sybase IQ connects clients on a Windows platform or the platform of the IQ server to the IQ server. To connect clients on other UNIX or Linux platforms to your server, download and install a platform–specific Sybase IQ ODBC Driver. Check the EBF/Update information on the Web for the appropriate driver.

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, you need to download and install the 32-bit ODBC driver kit. Check the EBF/Update information on the Web for the appropriate driver.