Skip to Content.
Sympa Menu

freetds - Syntax question...

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: mjn <mjn AT umn.edu>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Syntax question...
  • Date: Tue, 2 Jan 2001 10:56:32 -0600 (CST)


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/
____________________________





  • Syntax question..., mjn, 01/02/2001

Archive powered by MHonArc 2.6.24.

Top of Page