[freetds] SQL Server 2005 and TDS version 8
Adam Clark
adam.clark at ngv.vic.gov.au
Mon Sep 24 18:49:11 EDT 2007
I'm using the following:
DBD::Sybase -- 1.07
DBI -- 1.54
Perl -- 5.8.8
and the FreeTDS 0.64 (the stable tarball)
What does the patch do?
Is there anything such as dumps (I don't know how to produce these) of
debugging that I can produce to help this?
Adam
> -----Original Message-----
> From: freetds-bounces at lists.ibiblio.org
> [mailto:freetds-bounces at lists.ibiblio.org] On Behalf Of
> ZIGLIO, Frediano, VF-IT
> Sent: Monday, 24 September 2007 5:06 PM
> To: FreeTDS Development Group
> Subject: Re: [freetds] SQL Server 2005 and TDS version 8
>
> >
> > 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
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
Adam Clark
Network Administrator
National Gallery of Victoria
180 St Kilda Road Melbourne Vic 3004 Australia
Telephone: +61 3 8620 2369
Fax: +61 3 8620 2565
www.ngv.vic.gov.au
Keep informed of the latest NGV exhibitions, special events and programs at The Ian Potter Centre: NGV Australia and NGV International by subscribing to NGV at RT, the NGV's free e-newsletter.
DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for freetds at lists.ibiblio.org. If you are not the named addressee you should not disseminate, copy or alter this email. WARNING: Although National Gallery of Victoria has taken reasonable precautions to ensure no viruses are present in this email, the organisation cannot accept responsibility for any loss or damage arising from the use of this email or attachment.
More information about the FreeTDS
mailing list