The ODBC Driver Manager manages the communications between the user applications and the ODBC Drivers. Typically, user applications are linked against the ODBC Driver Manager. The Driver Manager manages the job of loading and unloading the appropriate ODBC Driver for the application. Applications make ODBC calls to the ODBC Driver Manager, which performs basic error checking and then processes these calls or passes them on to the underlying ODBC Driver.
The ODBC Driver Manager is not a required component, but it exists to solve many issues surrounding ODBC application development and deployment. Some advantages of using an ODBC Driver Manager are:
Portable data access: Applications do not need to be rebuilt to use a different DBMS.
Runtime binding to a datasource.
Ability to easily change a datasource.
To use the Adaptive Server ODBC Driver without using the ODBC Driver Manager, link your application directly to the Adaptive Server ODBC Driver library. The resulting executable connects only to Adaptive Server datasources.
The Adaptive Server ODBC Driver has been tested with these ODBC Driver Managers:
On Microsoft Windows, the Microsoft ODBC Driver Manager that is included with Microsoft Windows
On Linux, the unixODBC Driver Manager that is included with Red Hat and SuSE
On HP HP-UX, IBM AIX, and Solaris, the unixODBC Driver Manager version 2.2.14 and the Sybase iAnywhere ODBC Driver Manager included with the Adaptive Server ODBC Driver installation
Historically, the unixODBC Driver
Manager on 64-bit Linux platforms has expected a 4-byte SQLLEN from ODBC drivers. As of version 2.2.13, the unixODBC Driver
Manager expects an 8-byte SQLLEN datatype.
Starting with 15.7 ESD #4, Adaptive Server ODBC Driver
installation contains both 4-byte SQLLEN and
8-byte SQLLEN versions of the driver. The 4-byte
version is configured as the default. Please check the version of
your unixODBC Driver Manager, and, if it is 2.2.13 or later, change
your ODBC driver installation:
> cd ${SYBASE}/DataAccess64/ODBC/lib
> rm libsybdrvodb.so
> ln -s libsybdrvodb-sqllen8.so libsybdrvodb.so
Note that Red Hat Enterprise Linux version 6 and later use the 8-byte SQLLEN version of the unixODBC Driver Manager and thus require the aforementioned change.
