UnixODBC on Ubuntu 12.04 broken and unable to connect error 3


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 because it couldn’t find libmyodbc3_r-3.51.27.so.

The fix we fairly easy, I just ran a few new symbolic links and it worked.

Fix on my system:

ln -s /usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so /usr/lib/libmyodbc3_r-3.51.27.so

ln -s /usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so /usr/lib/libmyodbc.so

ln -s /usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so /usr/lib/odbc/libmyodbc.so

 

Now I could run: isql -v gregtest and it worked just fine!