FreeTDS Development Group

[Michael Peppler <mpeppler AT peppler.org>]

Richard Rowell writes:
 > The server is s MS-SQL Server v7.  I configured freetds to use TDS v7.  
 > When 
 > I connect to a (MS)SQL 2000 server I get differnet results, it just sais 
 > that 
 > the table dosen't exist (even though I'm positive that it does).  This all 
 > works fine from sqsh BTW.
 > 
 > This is the perl script I'm running, it is nearly a direct cut/paste from 
 > the 
 > DBI tutorial on perl.com (I replaced the password with XXXXXXXX):
 > 
 > #!/usr/bin/perl -w
 > use DBI;
 > use strict;
 > DBI->trace(3);
 > my $dbh = 
 > DBI->connect("DBI:Sybase:datbase=gths_dev;server=192.168.1.142","sa","XXXXXXXX")
 > 

Well - to start with there is a typo here. It should be
database=gths_dev - not datbase.

This query is trying to select from "agency" in the master database,
which is probably why there are no rows...

Michael
-- 
Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
mpeppler AT peppler.org - mpeppler AT mbay.net
International Sybase User Group - http://www.isug.com