Skip to Content.
Sympa Menu

freetds - Re: freetds .53 & DBD-SYbase .93 Returns no rows

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Michael Peppler <mpeppler AT peppler.org>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: freetds .53 & DBD-SYbase .93 Returns no rows
  • Date: Tue, 8 Jan 2002 08:23:59 -0800


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




Archive powered by MHonArc 2.6.24.

Top of Page