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

Jean-Roch Grenetier jgrenetier at hotmail.com
Thu Nov 17 16:19:27 GMT 2011

BINGO! Right on, your ldd pointed a 'not found' on one of the entries 'libodbcinst.so.1.0.0'. 
Yes an 'export LD_LIBRARY_PATH=/usr/local/lib' was the cure.
Dave, thank-you-so-much.

From: David.Ritter at roguewave.com
To: unixodbc-support at mailman.unixodbc.org
Date: Wed, 16 Nov 2011 17:28:56 -0700
Subject: Re: [unixODBC-support] Perl DBD-ODBC "Can't open lib '/usr/local/lib/libtdsodbc.so' : file not found (SQL-01000)"

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..
_______________________________________________ unixODBC-support mailing list unixODBC-support at mailman.unixodbc.org http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20111117/22aed07d/attachment.html>

More information about the unixODBC-support mailing list