Re: what am I missing?

Try TDSDUMPCONFIG to see all the connection params that TDS is using.

http://www.freetds.org/userguide/logging.htm

I don't see a server name or IP address, might that be the issue?

--------------------------------------
Randy Syring
Intelicom
Direct: 502-276-0459
Office: 502-212-9913

For the wages of sin is death, but the
free gift of God is eternal life in
Christ Jesus our Lord (Rom 6:23)


On 05/23/2011 11:51 PM, Chris Bartram wrote:
> 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
_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds