sybperl-l Archive

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