persistent connection problem
| From: | Viral Shah | Date: | Mon, 27 Mar 2006 09:56:28 +0000 |
| Subject: | persistent connection problem | ||
| Groups: | php.pear.webmaster | ||
| Request: | Send a blank email to pear-webmaster+get-4927@lists.php.net to get a copy of this message | ||
hi,
i am connecting the database through odbc
$dsn = array(
'phptype' => 'odbc',
'username' => 'dba',
'password' => 'root',
'hostspec' => 'localhost',
'database' => 'test',
);
$options = array(
'debug' => 2,
'portability' => DB_PORTABILITY_ALL,
'persistent' => true,
);
$db =& DB::connect($dsn, $options);
if (PEAR::isError($db)) {
die($db->getMessage());
}
the above code works fine to connect the database.
But mean time if server get restart.
$db =& DB::connect($dsn, $options); is not throughing
error..becouse server has termitted the client server...
so it should though the error message at connection time
whereas it is giving the error at $db->getAll($sql); function.
is that possible for connect method to check wheather server
has rejected our connection or not.
Please reply me....