[unixODBC-support] [01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/libtdsodbc.so.0.0.0' : file not found

José Luis Murcia Esquiva jmurcia.umh at gmail.com
Fri Dec 11 13:06:52 GMT 2015


Hi,

I have an VPS with CentOS 7 x64 Finale. It came with unixODBC x64 package
installed (for managing VPS's mysql). It came with perl x64, too.

Now I need to connect to a SQL Server R2 database. I was able to do it with
FreeTDS and unixODBC (both x64) through isql. But, since my final goal is
to connect that database to WebGUI (a perl-based CMS which has its own
32-bit perl), I must do the same in 32-bit.

So, I've installed (using yum) the following:
unixODBC-2.2.14-14.el6.i686
freetds-0.91-2.el6.i686 <- I deleted the previous x64 version

mysql-connector-odbc-5.1.5r1144-7.el6.x86_64 <- it came with the VPS
plesk-php56-odbc-5.6.16-centos6.15120116.x86_64 <- it came with the VPS
unixODBC-2.2.14-14.el6.x86_64 <- it came with the VPS

file /usr/bin/odbcinst <- tells it's a 64-bit executable
file /usr/local/bin/odbcinst <- tells it's a 64-bit executable

*Output for odbcinst -j*
unixODBC 2.3.4
DRIVERS............: /usr/local/etc/odbcinst.ini
SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini
FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources
USER DATA SOURCES..: /root/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8

*/usr/local/etc/odbcinst.ini*
[ODBC]
Trace=Yes
TraceFile=/tmp/sql.log
ForceTrace=Yes

[FreeTDS]
Description=v0.95.73
Driver=/usr/lib/libtdsodbc.so.0.0.0
UsageCount=1

*/usr/local/etc/odbc.ini*
[DSN]
Description=DNS description
Driver=/usr/lib/libtdsodbc.so.0.0.0
Server=XX.XX.XX.XX
Database=myDatabase
Port=1433 #sql server default port
TDS_Version=7.3

*Output for ldd /usr/lib/libtdsodbc.so.0.0.0*
linux-gate.so.1 =>  (0xb77a1000)
libodbcinst.so.2 => /usr/lib/libodbcinst.so.2 (0xb7729000)
libgssapi_krb5.so.2 => /lib/libgssapi_krb5.so.2 (0xb76de000)
libgnutls.so.26 => /usr/lib/libgnutls.so.26 (0xb7632000)
librt.so.1 => /lib/librt.so.1 (0xb7629000)
libgcrypt.so.11 => /lib/libgcrypt.so.11 (0xb75ac000)
libpthread.so.0 => /lib/libpthread.so.0 (0xb7591000)
libc.so.6 => /lib/libc.so.6 (0xb73fa000)
libltdl.so.7 => /usr/lib/libltdl.so.7 (0xb73f0000)
libkrb5.so.3 => /lib/libkrb5.so.3 (0xb7313000)
libk5crypto.so.3 => /lib/libk5crypto.so.3 (0xb72e8000)
libcom_err.so.2 => /lib/libcom_err.so.2 (0xb72e2000)
libkrb5support.so.0 => /lib/libkrb5support.so.0 (0xb72d6000)
libdl.so.2 => /lib/libdl.so.2 (0xb72d1000)
libkeyutils.so.1 => /lib/libkeyutils.so.1 (0xb72cd000)
libresolv.so.2 => /lib/libresolv.so.2 (0xb72b3000)
libtasn1.so.3 => /usr/lib/libtasn1.so.3 (0xb72a0000)
libz.so.1 => /lib/libz.so.1 (0xb728c000)
/lib/ld-linux.so.2 (0xb77a2000)
libgpg-error.so.0 => /lib/libgpg-error.so.0 (0xb7287000)
libselinux.so.1 => /lib/libselinux.so.1 (0xb7268000)

*Output for  echo$LD_LIBRARY_PATH*
:/usr/lib/

*isql DSN -v*
Returns the error displayer at the subject field of this e-mail.

What am I missing?
Thanks in advance.
Regards
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20151211/23f06102/attachment.html>


More information about the unixODBC-support mailing list