PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Michael Stather <statherm at home dot com>
Subject: Re: client api layer error
Date: Jun 6 2001 2:23PM

Do regular isql sessions between all of these machines work correctly?
What version of ASE, and openclient are you using?
I was running ASE 11.9.2 on RedHat 6.1 and everything worked without a hitch.
How about some of the samples, if you modify the user name and password etc. do
they work?

JMS

Patrick S Leung wrote:

> Dear all,
>
> I use a perl script to fetch data from sever sybase ase dbs.  The perl
> scripts are on one linux machine while the db is on another linux
> machine.  All but one sybase server gave me the open client error.  I
> got the error even if I run the perl script on the same machine.
>
> Open Client Message:
> Message number:  LAYER = (1) ORIGIN = (1)  SEVERITY = (1) NUMBER = (163)
> Message String:  ct_results():  user api layer: external error:  This
> routine cannot be called until all fetachable results have been
> completely processed.
>
> Open Client Message:
> Message number:  LAYER = (1) ORIGIN = (1)  SEVERITY = (1) NUMBER = (16)
> Message String:  ct_command():  user api layer: external error:  This
> routine cannot be called while results are pending for a command that
> has been sent to the server.
>
> ... repeat for every sql statement.
>
> The sql states are nothing complicated... just a single SELECT
> statement, executed by ct_execute.
>
> Could the sybase ASE version be a problem?  This db server actually was
> installed using one of the very early ase release.  If nothing helps, I
> will have to reinstall Sybase and compile sybperl again, as a last resort.
>
> Thanks
>
> Patrick