Linking ODBC applications on Unix

An ODBC driver manager for Unix is included with SQL Anywhere and there are third party driver managers available. This section describes how to build ODBC applications that do not use an ODBC driver manager.

ODBC driver

The ODBC driver is a shared object or shared library. Separate versions of the SQL Anywhere ODBC driver are supplied for single-threaded and multithreaded applications. A generic SQL Anywhere 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 Mac OS X and HP-UX)	Generic	libdbodbc12.so (libdbodbc12.so.1)
(all Unix except Mac OS X and HP-UX)	Single threaded	libdbodbc12_n.so (libdbodbc12_n.so.1)
(all Unix except Mac OS X and HP-UX)	Multithreaded	libdbodbc12_r.so (libdbodbc12_r.so.1)
HP-UX	Generic	libdbodbc12.sl (libdbodbc12.sl.1)
HP-UX	Single threaded	libdbodbc12_n.sl (libdbodbc12_n.sl.1)
HP-UX	Multithreaded	libdbodbc12_r.sl (libdbodbc12_r.sl.1)
Mac OS X	Generic	libdbodbc12.dylib
Mac OS X	Single threaded	libdbodbc12_n.dylib
Mac OS X	Multithreaded	libdbodbc12_r.dylib

The libraries are installed as symbolic links to the shared library with a version number (shown in parentheses).

In addition, the following bundles are also provided for Mac OS X:

Operating system	Threading model	ODBC driver
Mac OS X	Single threaded	dbodbc12.bundle
Mac OS X	Multithreaded	dbodbc12_r.bundle

To link an ODBC application (Unix)

Link your application against the generic ODBC driver libdbodbc12.
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.

Data source information

Discuss this page in DocCommentXchange.