Note: deliberately xposted to the two newsgroups which seem applicable,
after reading several hundred messages from various php groups.
Randomly my application gets the message:
Warning: odbc_connect(): SQL error: O*@|VA@§ÿ¿ Û,
SQL state ýÿÿÿ | ýà ¿Ã¿Ã¿Ã¼Ã˜\| ýÿÿÿˆªÿ ¿ËœEW@Ôªÿ¿ in
SQLConnect in /var/www/html/GEM/db.php on line 15
db.php is a common module used throughout my application. The error
(with various random trash in the middle) sometime occurs just as the
application is entered for the first time, sometimes after many
minutes/hours of successful operation. The routine, slightly masked for
security appears below. I am running php v 4.3.4 (--with-ibm-db2) and
db2 v 8.1.5 under apache 2.0 on redhat v 8.0.
Any assistance (including RTFM with references, because I have RTFM
until I am cross-eyed) would be greatly appreciated.
<?php
// vim: set ts=4 sw=4 ai:
function showerror($dbCo nn) {
echo "<br>";
echo "Error ".odbc_error($d bConn)." ".odbc_errormsg ($dbConn);
echo "<br>";
}
function conn() {
global $schema, $database;
$schema = "is3";
$database = "animalst";
$dbuser = "xxxxxxxx";
$dbpwd = "xxxxxxxx";
$dbConn = odbc_connect($d atabase,$dbuser ,$dbpwd);
if ( $dbConn===False ) {
showerror($dbCo nn);
die("could not connect to $database");
}
return $dbConn;
}
?>
after reading several hundred messages from various php groups.
Randomly my application gets the message:
Warning: odbc_connect(): SQL error: O*@|VA@§ÿ¿ Û,
SQL state ýÿÿÿ | ýà ¿Ã¿Ã¿Ã¼Ã˜\| ýÿÿÿˆªÿ ¿ËœEW@Ôªÿ¿ in
SQLConnect in /var/www/html/GEM/db.php on line 15
db.php is a common module used throughout my application. The error
(with various random trash in the middle) sometime occurs just as the
application is entered for the first time, sometimes after many
minutes/hours of successful operation. The routine, slightly masked for
security appears below. I am running php v 4.3.4 (--with-ibm-db2) and
db2 v 8.1.5 under apache 2.0 on redhat v 8.0.
Any assistance (including RTFM with references, because I have RTFM
until I am cross-eyed) would be greatly appreciated.
<?php
// vim: set ts=4 sw=4 ai:
function showerror($dbCo nn) {
echo "<br>";
echo "Error ".odbc_error($d bConn)." ".odbc_errormsg ($dbConn);
echo "<br>";
}
function conn() {
global $schema, $database;
$schema = "is3";
$database = "animalst";
$dbuser = "xxxxxxxx";
$dbpwd = "xxxxxxxx";
$dbConn = odbc_connect($d atabase,$dbuser ,$dbpwd);
if ( $dbConn===False ) {
showerror($dbCo nn);
die("could not connect to $database");
}
return $dbConn;
}
?>
Comment