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: "Herring, Nathan A" <nathan dot a dot herring at lmco dot com>
Subject: Two connections using CT-LIB
Date: Nov 3 1999 10:19PM

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.

Anyone have any ideas?

Thanks,
  Nate