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 Peppler <mpeppler at peppler dot org>
Subject: Re: Two connections using CT-LIB
Date: Nov 3 1999 10:43PM

Herring, Nathan A writes:
 > I am opening two connections to a server for execution of commands like the
 > following:
 > 
 > 	$X = Sybase::CTlib->ct_connect($uid, $pwd, $srv);
 > 	$Y = Sybase::CTlib->ct_connect($uid, $pwd, $srv);
 > 	$selgen = "select name from master..sysdatabases where dbid > 4 and
 > name != 'sybsecurity'";
 > 	$selgen2 = "select name from master..sysusers where uid > 4";
 > 	$X->ct_execute($selgen);
 > 	$Y->ct_execute($selgen2);
 > 
 > If I remove all $Y ct executes the program works fine.  If I leave them in I
 > get the following errors:
 > 
 > 	Message number: LAYER = (1) ORIGIN = (1) SEVERITY = (1) NUMBER =
 > (16)
 > 	Message String: ct_cmd_drop(): user api layer: external error: This
 > routine 
 > 		cannot be called while results are pending for a command
 > that has been 
 > 		sent to the server.
 > 	cs_loc_drop(context, locale) failed during global destruction.

Upgrade to a more recent version of Sybperl (2.11 is the current
release, 2.10_02 fixes the problem, I believe)

Michael
-- 
Michael Peppler         -||-  Data Migrations Inc.
mpeppler@peppler.org    -||-  http://www.mbay.net/~mpeppler
Int. Sybase User Group  -||-  http://www.isug.com
Sybase on Linux mailing list: ase-linux-list@isug.com