Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Adam Clark" <adam.clark AT ngv.vic.gov.au>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] SQL Server 2005 and TDS version 8
  • Date: Mon, 24 Sep 2007 14:34:06 +1000

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

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@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.




Archive powered by MHonArc 2.6.24.

Top of Page