SEO

#1 (**permalink**) 02-28-2008, 08:34 AM

Hi

I'm trying to call SP from PHP but I can do that only when i use
mysql_connect like this:

mysql_connect($dbsettings['dbhost'], $dbsettings['dbuser'],
$dbsettings['dbpass'], false, 65536);

When I try persistent connection:

mysql_pconnect($dbsettings['dbhost'], $dbsettings['dbuser'],
$dbsettings['dbpass'], 65536);

I'm getting error:

PROCEDURE findPath can't return a result set in the given
context[code]=> 1312

How can I use persistent connection with this flag?

I use
PHP 5.1.6
MySQL 5.0.24a-log

Thank you Ralph

#2 (**permalink**) 02-28-2008, 08:34 AM

On Mon, 13 Nov 2006 18:03:42 GMT, Ralph wrote:
>
> Hi
>
> I'm trying to call SP from PHP but I can do that only when i use
> mysql_connect like this:
>
> mysql_connect($dbsettings['dbhost'], $dbsettings['dbuser'],
> $dbsettings['dbpass'], false, 65536);
>
> When I try persistent connection:
>
> mysql_pconnect($dbsettings['dbhost'], $dbsettings['dbuser'],
> $dbsettings['dbpass'], 65536);
>
> I'm getting error:
>
> PROCEDURE findPath can't return a result set in the given
> context[code]=> 1312
>
> How can I use persistent connection with this flag?
>
> I use
> PHP 5.1.6
> MySQL 5.0.24a-log

What problem are you trying to fix? Does your call return an error when
you use a non-persistant connection? If so, what does it say? (I've used
stored procedures from PHP on both MqSQL and DB2, and it's been quite
succesful for my purposes.)

--
37. If my trusted lieutenant tells me my Legions of Terror are losing a
battle, I will believe him. After all, he's my trusted lieutenant.
--Peter Anspach's list of things to do as an Evil Overlord

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

PHP CLIENT_MULTI_STATEMENTS