ODBC - Driver Manager

Card Puncher Data Processing

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.

..

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

Documentation / Reference





Discover More
Card Puncher Data Processing
ODBC - unixODBC

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