RE: CTlib.pm error

Well - something's got to die in there somewhere.

The ct_res_info() should only fail if there is no result set to fetch.
Then the ct_cancel() error message occurs if a ct_fetch() returns
CS_FAIL *and* if a ct_cancel() also returns CS_FAIL.
The latter usually means that the connection has been marked "dead". Do
you have ad-hoc error handlers installed in your script?
If so, could you disable them while you run this code, or replace them
with something that prints out *all* the messages that they receive?

Michael

On Wed, 2004-11-10 at 17:22, Sabherwal, Balvinder (MBS) wrote:
> Nop!
> 
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On
> Behalf Of Michael Peppler
> Sent: Wednesday, November 10, 2004 11:02 AM
> To: '[email protected]'
> Subject: RE: CTlib.pm error
> 
> OK - well that's weird. The ct_res_info() call will normally only fail
> if the communication with the server has a problem of some sort. Are you
> sure that you don't get any other errors?
> 
> Michael
> 
> On Wed, 2004-11-10 at 15:20, Sabherwal, Balvinder (MBS) wrote:
> > Sybase errorlog is clean and there are no errors reported what so ever.
> > 
> > -----Original Message-----
> > From: Michael Peppler [mailto:[email protected]] 
> > Sent: Wednesday, November 10, 2004 1:58 AM
> > To: Sabherwal, Balvinder (MBS)
> > Cc: '[email protected]'
> > Subject: Re: CTlib.pm error
> > 
> > On Tue, 2004-11-09 at 20:30, Sabherwal, Balvinder (MBS) wrote:
> > > Hi list,
> > > 
> > > I'm getting error upon running one of my scripts as below. This happens
> > asap
> > > the sql is sent to the ASE for execution via ct_sql() method.
> > > 
> > > The same script is working fine for another ASE and is failing for this
> > ASE
> > > server. Any pointers on this? Below is the debug output.
> > 
> > >   DB<4> 
> > > ct_res_info() failed at
> > >
> >
> /usr/local/ActivePerl-5.6/lib/site_perl/5.6.1/sun4-solaris-thread-multi/Syba
> > > se/CTlib.pm line 906.
> > 
> > Take a look at the Sybase server error log. My guess is that you'll see
> > a stack trace of some sort that corresponds with this request.
> > 
> > Michael
-- 
Michael Peppler                              Data Migrations, Inc.
[email protected]                       http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or 
long term contract positions - http://www.peppler.org/resume.html