An ODBC driver manager for Unix is included with SAP Sybase IQ and there are third party driver managers available. This section describes how to build ODBC applications that do not use an ODBC driver manager.
The ODBC driver is a shared object or shared library. Separate versions of the SAP Sybase IQ ODBC driver are supplied for single-threaded and multithreaded applications. A generic SAP Sybase IQ ODBC driver is supplied that will detect the threading model in use and direct calls to the appropriate single-threaded or multithreaded library.
The ODBC drivers are the following files:
| Operating system | Threading model | ODBC driver |
|---|---|---|
| (all Unix except HP-UX) | Generic | libdbodbc16.so (libdbodbc16.so.1) |
| (all Unix except HP-UX) | Single threaded | libdbodbc16_n.so (libdbodbc16_n.so.1) |
| (all Unix except HP-UX) | Multithreaded | libdbodbc16_r.so (libdbodbc16_r.so.1) |
| HP-UX | Generic | libdbodbc16.sl (libdbodbc16.sl.1) |
| HP-UX | Single threaded | libdbodbc16_n.sl (libdbodbc16_n.sl.1) |
| HP-UX | Multithreaded | libdbodbc16_r.sl (libdbodbc16_r.sl.1) |
The libraries are installed as symbolic links to the shared library with a version number (shown in parentheses).
When linking an ODBC application on Unix, link your application against the generic ODBC driver libdbodbc16. When deploying your application, ensure that the appropriate (or all) ODBC driver versions (non-threaded or threaded) are available in the user's library path.
If SAP Sybase IQ does not detect the presence of an ODBC driver manager, it uses the system information file for data source information.