No, actually there is no limitation for the number of connection to the
database ...
Thanks
Daniel
Jochem Maas wrote:
is it possible that you are only allowing a single connection (or a
number of
them) and that when apache comes up it's child processes eat up all the
[persistent?] connections so that there are none left for any other
process?
HENCHOZ Daniel wrote:
Hello,
I've installed a SUN server under Solaris 9 with Apache 2.0.55, PHP
5.1.1, Informix 9.40.UC6, Informix Client SDK 2.90.UC3, Informix
Webdatablade 4.13.UC3. Now I try to get information from the Informix
database via a PHP ifx_connect function and on the same apache server
using the Informix webdatablade tool (old pages not yet migrated ...).
The php and informix modules are loaded in the apache httpd.conf :
#IBM Informix Web DataBlade DSO Module Added
LoadModule informix_module
/d3/apache2/wwwdbdev/ifmx-bin/drvapch2.so
# Load the necessary PHP modules
LoadModule php5_module modules/libphp5.so
I'm not able to have php and webdatablade connections to informix
work together ...
Case 1:
-------
If I load the informix module first in the httpd.conf file the php
ifx functions doesn't work and I get the following incomplete error
message :
*Warning*: ifx_connect() [function.ifx-connect
<https://furio.unil.ch/php-dhz/function.ifx-connect>]: E [SQLSTATE=
in */d3/apache2/wwwdbdev/php-dhz/testifmx.php* on line *3*
*Warning*: ifx_query(): supplied argument is not a valid Informix
link resource in */d3/apache2/wwwdbdev/php-dhz/testifmx.php* on line *4*
*Warning*: printf() [function.printf
<https://furio.unil.ch/php-dhz/function.printf>]: Too few arguments
in */d3/apache2/wwwdbdev/php-dhz/testifmx.php* on line *7*
The php script is below :
<?php
$ConnId = ifx_connect ("aaaa@bbbbb","xxxxxx","xxxxxx");
$ResId = ifx_query ("SELECT * FROM dhtable", $ConnId);
if (! $ResId) {
printf("Can't select names : %s\n<br />%s<br />\n", ifx_error());
ifx_errormsg();
die;
}
ifx_htmltbl_result($ResId, "border=\"1\"");
ifx_free_result($ResId);
ifx_close($ConnId);
?>
On the other hand the webdatablade connection works normally ...
Case 2:
-------
If I load the php module before the informix module in the httpd.conf
file, the php ifx_connect function works correctly, but now the
wedatablade connection fails (never answer) ....
I need the two ways to connect to the database, since we actually
still use both .... I've asked IBM for a solution, but they propose
me to submit this problem to PHP people since IBM didn't develop the
ifx functions to connect to the informix database via PHP.
Any help would be appreciated !
Best regards
Daniel
--
###########################################################################
Daniel HENCHOZ /// WEB : http://www.danielhenchoz.ch
Computer center /// EMAIL : Daniel.Henchoz@xxxxxxx
University of Lausanne /// MOBILE/SMS: ++41 79 206.51.81
Amphimax /// FAX : ++41 21 692.22.49
1015 LAUSANNE /// PHONE : ++41 21 692.22.20
SWITZERLAND ///
###########################################################################
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
