FreeTDS Development Group

[mjn <mjn AT umn.edu>]

I am having some problems and I am not quite sure if i have a valid
connect string...

#!/usr/bin/perl -w
use DBI;

$user="user";
$passwd="pass";

my $dbh = DBI->connect('DBI:Sybase:pubs:server=SQLDATA', $user, $passwd,
                {RaiseError => 1,AutoCommit => 0}) || die "Couldn't
connect to database: "$

my $sth = $dbh->prepare('SELECT * FROM authors')
       || die "Couldn't prepare statement: " . $dbh->errstr;
$sth->execute();

$dbh->disconnect;


The part i am wondering about is "DBI:Sybase:pubs:server=SQLDATA"...and
the reason i wonder is because I am trying extract data from the authors
table in that pubs DB and whenever i run this program I get this:

DBD::Sybase::st execute failed: Server message number=208 severity=16
state=1 line=1 server=SQLDATA text=Invalid object name 'authors'. at
./query1.pl line 19. 
Database handle destroyed without explicit disconnect.

Suggestions?  I think this is correct but I cannot imagine why it cannot
find the table...I am connecting on another machine with Microsoft Access
and i can see the indicated table just fine.

____________________________
Mike Neuharth
ADCS Technology Specialist
http://www.umn.edu/adcs

E-Mail          : mjn AT umn.edu
Page Mail       : 6126486512 AT page.metrocall.com
http://nifty.dsl.visi.com/
____________________________