freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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
-
[freetds] SQL Server 2005 and TDS version 8,
Adam Clark, 09/24/2007
-
Re: [freetds] SQL Server 2005 and TDS version 8,
ZIGLIO, Frediano, VF-IT, 09/24/2007
-
[freetds] SQL Server 2005 and TDS version 8 -- is login always encapsulated in TLS (encrypted)?,
crawford charles, 09/24/2007
-
Re: [freetds] SQL Server 2005 and TDS version 8 -- is login always encapsulated in TLS (encrypted)?,
Bob Hetzel, 09/24/2007
- Re: [freetds] SQL Server 2005 and TDS version 8 -- is login always encapsulated in TLS (encrypted)?, Achim Grolms, 09/24/2007
- Re: [freetds] SQL Server 2005 and TDS version 8 -- is login alwaysencapsulated in TLS (encrypted)?, ???, 09/26/2007
-
Re: [freetds] SQL Server 2005 and TDS version 8 -- is login always encapsulated in TLS (encrypted)?,
Bob Hetzel, 09/24/2007
-
[freetds] SQL Server 2005 and TDS version 8 -- is login always encapsulated in TLS (encrypted)?,
crawford charles, 09/24/2007
- Re: [freetds] SQL Server 2005 and TDS version 8, David Barnwell, 09/24/2007
- <Possible follow-up(s)>
- Re: [freetds] SQL Server 2005 and TDS version 8, Adam Clark, 09/24/2007
-
Re: [freetds] SQL Server 2005 and TDS version 8,
ZIGLIO, Frediano, VF-IT, 09/24/2007
Archive powered by MHonArc 2.6.24.