Monday, October 17, 2016

[01000][unixODBC][Driver Manager]Can't open lib…file not found

I have installed a new BOXI system and working on unixODBC configuration to connect to Microsoft SQLServer Database and received below error message

$ isql -v test_ds test_username test_password
[01000][unixODBC][Driver Manager]Can't open lib '/u01/boxi/app/testsrv/sap_bobj/enterprise_xi40/linux_x64/ odbc/7.0.1/lib/' : file not found
[ISQL]ERROR: Could not SQLConnect

First I thought the issue with invalid patch and I have corrected the issue but I still see same error

It looks like LD_LIBRARY_PATH was not updated properly, which might be reason it’s not able to find the library. I have updated the updated LD_LIBRARY_PATH and I was able to connect successfully.

In some cases you will see the same error, if all dependent libraries are not installed. Run “ldd on the library /u01/boxi/app/testsrv/sap_bobj/enterprise_xi40/linux_x64/odbc/lib/ to ensure all dependencies are found. If something not found in below output then required PRM’s or soft links are missing.

$ ldd /u01/boxi/app/testsrv/sap_bobj/enterprise_xi40/linux_x64/odbc/lib/ => (0x00007ffd43be6000) => /lib64/ (0x00007fc9cf77e000) => /lib64/ (0x00007fc9cf575000) => /u01/boxi/app/biqapp/sap_bobj/enterprise_xi40/linux_x64/odbc/7.0.1/lib/ (0x00007fc9ce67e000) => /u01/boxi/app/biqapp/sap_bobj/enterprise_xi40/linux_x64/odbc/7.0.1/lib/ (0x00007fc9ce45a000) => /lib64/ (0x00007fc9ce255000) => /usr/lib64/ (0x00007fc9cdf4f000) => /lib64/ (0x00007fc9cdccb000) => /lib64/ (0x00007fc9cd936000) => /lib64/ (0x00007fc9cd720000)
/lib64/ (0x0000003ebc200000)

Regards ,
Satishbabu Gunukula, Oracle ACE