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!