[unixODBC-support] Perl DBD-ODBC "Can't open lib '/usr/local/lib/libtdsodbc.so' : file not found (SQL-01000)"

David Ritter David.Ritter at roguewave.com
Thu Nov 17 00:28:56 GMT 2011

Without any additional information, I'd be suspicious that either:

1)      There is a binary mis-match (32-bit unixODBC and 64-bit libtds or visa versa).

2)      Do not have /usr/local/lib in your LD_LIBRARY_PATH or LD_LIBRARY_PATH64

What is the output when you execute:
  ldd /usr/local/lib/libtdsodbc.so

Just my 2 cents.  Hopefully some of that helps.


From: unixodbc-support-bounces at mailman.unixodbc.org [mailto:unixodbc-support-bounces at mailman.unixodbc.org] On Behalf Of Jean-Roch Grenetier
Sent: Wednesday, November 16, 2011 3:57 PM
To: unixodbc-support at mailman.unixodbc.org
Subject: [unixODBC-support] Perl DBD-ODBC "Can't open lib '/usr/local/lib/libtdsodbc.so' : file not found (SQL-01000)"


I've got a:

[unixODBC][Driver Manager] Can't open lib '/usr/local/lib/libtdsodbc.so' : file not found (SQL-01000)

on executing a Perl script (that works without any problem on a TEST environement) even though the file is present:

lrwxrwxrwx    1 root     root           19  Nov 14 17:02 /usr/local/lib/libtdsodbc.so -> libtdsodbc.so.0.0.0
-rwxr-xr-x    1 root     root       777051 Nov 16 16:41 /usr/local/lib/libtdsodbc.so.0.0.0

Some hints:

1) freeTDS   successfully installed and tsql responsive (executes "SELECT * FROM customer WHERE customer = ..."  )
2) unixODBC successfully installed and isql  responsive (executes "SELECT * FROM customer WHERE customer = ..."  )
3) DBD-ODBC installed but with a number of failed tests and warning of older versions:
Warning: prerequisite DBI 1.609 not found. We have 1.59.
Warning: prerequisite Test::Simple 0.9 not found. We have 0.62.
However, with the same, slightly older DBI version DBD-ODBC is working on our TEST environment, so:
4)  DBD-ODBC installed and responsive (executes "SELECT * FROM customer WHERE customer = ..."  ) on TEST environement same than PROD, same DBI 1.59..

Any clues appreciated. Thanks in advance..

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

More information about the unixODBC-support mailing list