ASA Programming Guide
ODBC Programming
Building ODBC applications
An ODBC Driver Manager is not included with Adaptive Server Anywhere, but 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 Adaptive Server Anywhere ODBC driver are supplied for single-threaded and multi-threaded applications.
The ODBC drivers are the following files:
Operating system | Threading model | ODBC driver |
---|---|---|
Solaris/Sparc | Single threaded | dbodbc9.so (dbodbc9.so.1) |
Solaris/Sparc | Multi-threaded | dbodbc_r.so (dbodbc_r.so.1) |
The libraries are installed as symbolic links to the shared library with a version number (in parentheses).
To link an ODBC application (UNIX)
Link your application directly against the appropriate ODBC driver.
When deploying your application, ensure that the appropriate ODBC driver is available in the user's library path.
If Adaptive Server Anywhere does not detect the presence of an ODBC Driver Manager, it uses ~/.odbc.ini for data source information.
Using an ODBC Driver Manager on UNIX