I'm following this tutorial on Adding an ODBC driver to Ubuntu.

I installed iODBC and then I went to install libmyodbc and noticed that it uninstalled iODBC, and now I can't follow the rest of the tutorial...because either the driver is gone, or the GUI to install the driver is gone.

iodbcadm-gtk is part of the iODBC package but when libmyodbc is installed it removes the iODBC, rendering it useless.


Okay figured this out. I ended up installing just libmyodbc and configuring odbc using the /etc/odbc.ini file:

[ODBC Data Sources]
odbcname = MyODBC 3.51 Driver DSN

Driver = /usr/lib/i386-linux-gnu/odbc/libmyodbc.so
Description = The Database using MyODBC 3.51 Driver DSN
SERVER = localhost
USER = root
Password = someOldPassword
Database = the_db

It works great!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.