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!

 

 

  • Andrew Maurer

    Thanks!

  • Andrew

    I just upgraded from Debian 6 to 7 and this fixed an issue I was having with Asterisk ODBC logging, thanks!

    • Greg Fischer

      Nice! Glad that worked for ya! Thx for the comment too!