Skip to Content.
Sympa Menu

freetds - Re: [freetds] SQL Server 2005 and TDS version 8

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] SQL Server 2005 and TDS version 8
  • Date: Mon, 24 Sep 2007 09:06:05 +0200

>
> Hi all,
> I have been using some perl scripts with SQL 2000 for a
> while now and
> our organisation is looking to use 2005 in the near future.
>
> The only way I can get a connection to SQL 2005 is to lower my TDS
> version to 7.0.
>
> This does not help me as I require the BIGINT functionality
> that exists
> with 8.0
>
> The SQL 2000 server is virtuoso, 2005 is bunny.
>
> [virtuoso]
> host = virtuoso.boh.ngv.local
> port = 1433
> tds version = 8.0
>
> [bunny]
> host = bunny.boh.ngv.local
> port = 1433
> tds version = 7.0
>
> if I change the TDS version to 8.0 then there is a huge pause before
> failing. I have tested the SQL authentication with other
> tools such as
> the SQL 2000 Query analyser.
>
> my script (db-test2.pl) is:
> use DBI;
> $dbh = DBI->connect("dbi:Sybase:server=bunny", "sa" , "sapasswd" ,
> {PrintError => 0,
> RaiseError => 0,
> PrintWarn => 0,
> AutoCommit => 0 });
>
> print "Unable to connect\n" unless defined( $dbh );
>
> push( @I_Errors , "DBI Error: " . $DBI::errstr ) if ( $DBI::err );
>
> if ( @I_Errors ) {
> foreach ( @I_Errors ) {
> chomp;
> print "$_\n";
> }
> exit 127;
> }
>
> when run:
>
> [aclark@chromium common]$ ./db-test2.pl
> #### Insert long wait here ####
> Unable to connect
> DBI Error: OpenClient message: LAYER = (0) ORIGIN = (0)
> SEVERITY = (78)
> NUMBER = (36)
> Server bunny, database
> Message String: Read from SQL server failed.
> OpenClient message: LAYER = (0) ORIGIN = (0) SEVERITY = (78) NUMBER =
> (46)
> Server bunny, database
> Message String: Login incorrect.
>
> Any ideas?
>
> Cheers
>
>
> Adam Clark
> Network Administrator
>

Which FreeTDS version are you using?
Are you using domain authentication?
If you are using 0.64 did you apply patch at
http://freetds.sourceforge.net/?

freddy77




Archive powered by MHonArc 2.6.24.

Top of Page