ODBC - Driver Manager
About
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.
Articles Related
..
Installation
Yum
yum install unixODBC-devel
Manually
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
./configure
make
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
Example
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
Library
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