[freetds] SQL Server 2005 and TDS version 8
ZIGLIO, Frediano, VF-IT
Frediano.Ziglio at vodafone.com
Mon Sep 24 03:06:05 EDT 2007
>
> 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 at 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
More information about the FreeTDS
mailing list