Databases

UnixODBC on Ubuntu 12.04 broken and unable to connect error 3

 in Databases / Linux  tagged Databases / Linux / ODBC / ubuntu by

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 not found We also couldn’t run our Acucobol apps anymore […]

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

 in Databases / Linux / Ubuntu  tagged Databases / Linux / Mysql / Postgresql / ubuntu by

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 an postgresql first. :) # install unixodbc apt-get install unixodbc […]