Posts

Showing posts from September, 2014

ODBC - Testing odbc.ini in Linux

It is always best to test the ODBC configuration in the odbc.ini externally before doing real work with the database. Before putting the commands right away, below is a brief description about ODBC

ODBC, Open Database Connectivity, objective is to provide a standard API for accessing DBMS. It has 2 parts, the driver manager and the driver.

Driver Manager

It is a layer between the application and the actual driver. It actual functions include resolving DSN (Data Source Name) through the odbc.ini, loading and unloading the actual driver and pass application database calls to the driver.

The common ODBC Driver Manager are

Windows -  Microsoft Windows ODBC Driver Manager (odbc32.dll).

Unix - 2 commons Unix Driver Manager are

unixODBC Driver Manager for Unix (libodbc.so). See http://www.unixodbc.org, for more information.

iODBC Driver Manager for Unix (libiodbc.so). See http://www.iodbc.org, for more information.

Driver

It is vendor specific. When the Driver Manager passes the standard data…