Re: what am I missing?
Chris Bartram <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
Thanks! Took care of the Perl .so loading issues...
/usr/local/bin/tsql connection now working; I can connect and query data that
way.
Perl dbi:ODBC fails with following error codes:
DBI connect('SQLServer','user',...) failed: [unixODBC][FreeTDS][SQL
Server]Unable to connect to data source (SQL-08001) [state was 08001 now 01000]
[unixODBC][FreeTDS][SQL Server]Adaptive Server connection failed (SQL-01000)
[unixODBC][FreeTDS][SQL Server]Unexpected EOF from the server (SQL-01000) at
./testscom.pl line 9
Source looks like this:
$dbh = DBI->connect("dbi:ODBC:SQLServer","user",$userpass);
(also tried the DRIVER={};Server= format; same errors.)
Target server is a SQL 2005 cluster; default instance – not a named
instance.Calling from perl on a RHEL system.
Any suggestions?
-Chris Bartram
"The purpose of life is not to be happy. It is to be useful, to be honorable,
to be compassionate, to have it make some difference that you have lived and
lived well". (Ralph Waldo Emerson)
________________________________
From: James K. Lowden <[email protected]>
To: [email protected]
Sent: Wed, May 18, 2011 11:04:43 PM
Subject: Re: [freetds] what am I missing?
On Tue, 17 May 2011 19:30:17 -0700 (PDT)
Chris Bartram <[email protected]> wrote:
> When I try the ODBC connection in a Perl program I get
> errors that the .so is not found; yet an ls shows the file(s) right
> where it's supposed to be looking. tsql looks like it might be
> working?
http://www.freetds.org/91/userguide/linker.how.htm
If Perl says it can't find the .so, it's telling the truth. Because
Perl::DBI is using dlopen(3), nothing in the Perl executable nor the
DBI library affects where the runtime linker looks. You have to tell
it. LD_LIBRARY_PATH is your friend, but you may have to resort to
LD_PRELOAD.
HTH.
--jkl
_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds
_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds