Home / ubuntu / Questions / 137334
Accepted
leeand00
Asked: 2012-05-16 05:32:57 +0800 CST

Can't install both libmyodbc and iODBC at the same time on Ubuntu 12.04?

  • 772

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.

mysql database 12.04

1 Answers

  1. Best Answer

    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

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

    It works great!

    • 2