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/ASIQ-12_7/lib/libdbodbc9.so.1 for single threaded or $SYBASE/ASIQ-12_7/lib/libdbodbc9_r.so.1 for multi-threaded applications. If you are creating an ODBC application, you can link directly to libdbodbc9.so for non-threaded applications and libdbodbc9_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. See “Linking ODBC applications on UNIX” in
Chapter 7 of the Adaptive Server Anywhere Programming
Guide for a list of files included in the driver managers
for supported UNIX platforms.
You need to install the Sybase IQ Client Components on each client computer in your network, which contains the Sybase IQ 32-bit ODBC Driver.
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, following the steps in “Sybase EBFs and software maintenance”.
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 a 32-bit ODBC driver for connecting from Windows-based ODBC applications. The Sybase IQ CD for a 64-bit Sybase IQ server contains a 64-bit ODBC driver.
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, following the steps in the procedure “Sybase EBFs and software maintenance”.
