Install the ODBC in Linux and connect that to your database

To install the ODBC driver and then connect that to your Database follow the below steps:

1- To install ODBC run the below command from terminal

    sudo apt-get install unixodbc-dev unixodbc-bin unixodbc

2- To install ODBC driver run the below command from terminal

    sudo apt-get install libmyodbc

3- To check ODBC is running or not run the below command:

    isql

5- Now define the below lines in odbc.ini file:

    [mysql-db-source]
    Driver=/usr/lib/i386-linux-gnu/odbc/libmyodbc.so
    Server=localhost
    Port=3306
    User=root
    Password=
    Database=test

5 - To check connection through ODBC to your database

    isql -v mysql-db-source

Hope this will help you :)

You can also see such more Blogs at http://findnerd.com/NerdDigest/