Tag: Databases

UnixODBC on Ubuntu 12.04 broken and unable to connect error

Screen Shot 2012-09-07 at 9.40.50 AM

Recently I upgrade to Ubuntu 12.04. We had UnixODBC running fine in 10.04, but something changed because the odbc drivers couldn’t be found.  I got an error while running isql: isql -v gregtest [01000][unixODBC][Driver Manager]Can’t open lib ‘/usr/lib/odbc/libmyodbc.so’ : file

Posted in Databases, Linux Tagged with: , , ,

UnixODBC example setup and configuration on Ubuntu Lucid with Mysql and PostgreSQL using the command line only

Below is a very quick example of what I did to configure a system DSN connection to a Mysql and PostgreSQL database using UnixODBC drivers on Ubuntu Lucid server from command line only.   # Do the obvious, install mysql

Posted in Databases, Linux, Ubuntu Tagged with: , , , ,