Sybase::CTlib errors

plockhart has asked for the wisdom of the Perl Monks concerning the following question:

Howdy y'all! I'm trying to get Sybase::CTlib working so I can write an interface for a third party we're dealing with. My first shot at Sybase::CTlib. No matter what I do it seems, I get:

Server message: Message number: 208, Severity 16, State 1, Line 1 Server 'ADS' Message String: Edition not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).

These tables exist, and with isql the queries run.

I'm using a simple query to learn the ropes with this:

#!/usr/local/bin/perl -w

use strict;
#use Date::Manip;
use Sybase::CTlib;
     
  
my $restype = "";
my $edition = "";
my $dbh = new Sybase::CTlib 'uid', 'pwd', 'ads',
 { CON_PROPS => { CS_SYB_CHARSET => 'utf8bin'}
                   };


    my @dat =$dbh->ct_sql("select code from Edition");
    print @dat;
[download]

Being newest to it, I'd appreciate any and all help I can get! Thanks.

Comment on Sybase::CTlib errors Download Code

Replies are listed 'Best First'.
Re: Sybase::CTlib errors by roboticus (Chancellor) on Mar 21, 2012 at 21:53 UTC
plockhart: I don't see PagePosition anywhere in your code--are you sure you're showing us the correct error message and/or code? Anyway, since it's complaining about something not being present, the first thing I'd do is verify that you're in the correct database. (I know you can have a default database for a login, so this may not be relevant, but that's the first thing that comes to mind.) ...roboticus When your only tool is a hammer, all problems look like your thumb.	[reply]
Re: Sybase::CTlib errors by JavaFan (Canon) on Mar 21, 2012 at 23:25 UTC
Did you switch to the correct database? Do you own the table? Do note that Sybase has excellent documentation. Both in dead tree format, and online at Sybooks (both the books and the online format are generated from the same SGML source). Error 208 This does not seem a Perl issue to me.	[reply]