ODBC - Driver Manager

Card Puncher Data Processing


The Driver manager of unixODBC allows an application to connect concurrently to different types of data source and then using more than one ODBC drivers at a time.

A driver manager itself implements and exposes the ODBC API, thus the application can link directly to the driver manager library instead of the individual ODBC Driver libraries.

Based on some configuration data or other mechanism, the driver manager will dynamically load the relevant ODBC Driver libraries at runtime as the application requires them.

The driver manager sits between the application and the individual ODBC drivers and arbitrates all ODBC calls.

The application can then connect concurrently to multiple datasources, using different ODBC drivers.




yum install unixODBC-devel


The driver manager is part of unixodbc. See Download page

The install uses the standard GNU autoconf process. So its simply a matter of running

make install

By default the files are installed into /usr/local. As is usual with configure, this location can be changed by altering the prefix option to configure. i.e.

./configure --prefix=/usr/local/unixODBC
# Will install the lib, bin, include and etc directories in /usr/local/unixODBC/lib etc.

To conform with the GNU guidelines the odbcinst file is now installed by default in {prefix}/etc, this can be altered using the –sysconfdir option to configure. To install the files in the old default /etc you would run configure like this

./configure --sysconfdir=/etc 


cd <Download Folder>
wget ftp://ftp.unixodbc.org/pub/unixODBC/unixODBC-2.3.4.tar.gz
tar -xf unixODBC-2.3.4.tar.gz
cd unixODBC-2.3.4/
./configure --sysconfdir=/etc 1> conf_std.log 2> conf_err.log
make 1> mk_std.log 2> make_err.log
sudo make install 1> mki_std.log 2> mki_err.log


Driver Manager library:

  • /usr/lib/libodbcinst.so
  • /usr/lib/libodbc.so

The can also be installed in /usr/local/lib ?

Version: See the link

[oracle@euramsodw010 (OBI Profile) lib]$ ll
lrwxrwxrwx 1 root root      20 May 18  2015 libodbcinst.so -> libodbcinst.so.2.0.0
lrwxrwxrwx 1 root root      20 May 18  2015 libodbcinst.so.2 -> libodbcinst.so.2.0.0
lrwxrwxrwx 1 root root      16 May 18  2015 libodbc.so -> libodbc.so.2.0.0
lrwxrwxrwx 1 root root      16 May 18  2015 libodbc.so.2 -> libodbc.so.2.0.0
-rwxr-xr-x 1 root root 1831099 May 18  2015 libodbc.so.2.0.0

Documentation / Reference

Discover More
Card Puncher Data Processing

unixodbc notes. See Make sure that /lib is in the beginning of the libray path environment variable: LD_LIBRARY_PATH for Linux/Solaris LIB_PATH for AIX DYLD_LIBRARY_PATH...
Card Puncher Data Processing
Oracle Database - ODBC Driver Insallation on Linux

where is the data manager home () and ~/.odbc.ini === Drivers === Example odbcinst.ini === DSN === odbc.ini Minimal parameters Complete: ==== Test it ==== with ===== Support...

Share this page:
Follow us:
Task Runner