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_6/lib/dbodbc9.so.1 for single threaded or $SYBASE/ASIQ-12_6/lib/dbodbc9_r.so.1. If you are creating an ODBC application, you can link directly to dbodbc9.so for non-threaded applications and dbodbc9_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. The Sybase IQ 32-bit ODBC Driver is shipped with Sybase IQ as part of the Network Client CD and installed automatically.
If you are using ODBC with UNIX or Linux, see “Using ODBC without the driver manager” in Chapter 4 of the Adaptive Server Anywhere Programming Interfaces Guide to ensure that you are using the correct driver.
The ODBC Driver shipped with Sybase IQ connects Sybase IQ servers with clients on a Windows platform or the platform of the IQ server. To connect clients on 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 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”.
