FreeTDS Development Group

["Adam Clark" <adam.clark AT ngv.vic.gov.au>]

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.