October 25, 2010

HOWTO Configure Unix ODBC

Learn how to configure Unix ODBC with mySQL on CentOS using myODBC and unixODBC. Step-by-step commands for setting up and testing DSN connections.

Taken from: How to setup a mySQL (DSN) datasbase source in CentOS with myODBC and unixODBC command line

odbcinst -j
vi /etc/odbcinst.ini
vi /etc/odbc.inst
odbcinst -i -d -f /etc/odbcinst.ini
odbcinst -i -s -l -f /etc/odbc.ini
odbcinst -s -q
isql -v