[unixODBC-support] Can't open lib error

Franck Lebastard Franck.Lebastard at inovmedia.com
Thu Feb 23 13:51:33 GMT 2012


Hi all,

 

I am using unixODBC 2.3.1 on Debian lenny (uname –a: Linux voyager
2.6.26-2-686 #1 SMP Wed Sep 21 04:35:47 UTC 2011 i686 GNU/Linux) with MySQL
(server: 5.0.51a-24+lenny5) and it works great (thanks all!).

 

Recently, I decided to update MySQL driver and I downloaded the last release
(mysql-connector-odbc-5.1.10-linux-glibc2.3-x86-32bit.tar.gz). I installed
it correctly using odbcinst but I was not able to use it.

 

SQLConnect definitively generates the following error:

 

ODBC SQLConnect error code= -1 [SQLState='01000' SQLMsg='[unixODBC][Driver
Manager]Can't open lib '/usr/lib/odbc/libmyodbc5.1.10.so' : file not found'
] 

 

In the past, with the current driver, I also (rarely) got the same ‘file not
found’ error for an SQLConnect call among others.

 

Once, the same error happened and then definitely occurred for all next
calls to SQLConnect. I had to kill the application and re-run it to get
SQLConnect working again.

 

Hope this helps.

 

Best regards,

Franck 

 

$ cat /usr/local/etc/odbcinst.ini

[MySQL51]

Description=MySQL 5.1.8 driver for Linux

Driver=/usr/lib/odbc/libmyodbc5.so

Setup=/usr/lib/odbc/libmyodbc3S.so

UsageCount=1

 

[MySQL5_1_10]

Description=MySQL 5.1.10 driver for Linux

Driver=/usr/lib/odbc/libmyodbc5.1.10.so

UsageCount=1

 

$ ls –l /usr/lib/odbc/

total 18584

-rw-r--r-- 1 root root    6048 jui 27  2007 libesoobS.so

-rw-r--r-- 1 root root    5108 jui 27  2007 libmimerS.so

-rwxr-xr-x 1 root root 6848380 oct 28  2010 libmyodbc3S-5.1.8.so

-rwxr-xr-x 1 root root    1356 oct 28  2010 libmyodbc3S.la

lrwxrwxrwx 1 root root      20 déc 19  2010 libmyodbc3S.so ->
libmyodbc3S-5.1.8.so

-rwxr-xr-x 1 root root 6860680 jan 24 17:26 libmyodbc5.1.10.so

-rwxr-xr-x 1 root root 5019872 oct 28  2010 libmyodbc5-5.1.8.so

-rwxr-xr-x 1 root root    1244 oct 28  2010 libmyodbc5.la

lrwxrwxrwx 1 root root      19 fév  9 15:51 libmyodbc5.so ->
libmyodbc5-5.1.8.so

-rw-r--r-- 1 root root  166848 jun 22  2008 libmyodbc.so

-rw-r--r-- 1 root root    3160 jui 27  2007 libodbcdrvcfg1S.so

-rw-r--r-- 1 root root    2860 jui 27  2007 libodbcdrvcfg2S.so

-rw-r--r-- 1 root root    3324 jui 27  2007 libodbcminiS.so

-rw-r--r-- 1 root root    5912 jui 27  2007 libodbcmyS.so

-rw-r--r-- 1 root root    2908 jui 27  2007 libodbcnnS.so

-rw-r--r-- 1 root root    5624 jui 27  2007 libodbcpsqlS.so

-rw-r--r-- 1 root root    4556 jui 27  2007 libodbctxtS.so

-rw-r--r-- 1 root root    5840 jui 27  2007 liboplodbcS.so

-rw-r--r-- 1 root root    3780 jui 27  2007 liboraodbcS.so

-rw-r--r-- 1 root root    3032 jui 27  2007 libsapdbS.so

-rw-r--r-- 1 root root    4104 jui 27  2007 libtdsS.so

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20120223/f94b2877/attachment.html>


More information about the unixODBC-support mailing list