Sybase Connection Problem

[admin]

Hi,

I have very strange problem. I'm using php with sybase-ct library.

Here is what happens

I'm using phplib db_sybase.inc to connect to the database. When this function is called the first time it gives and error "cannot use database xxxx" but if reload the page everything works fine.

I have also notice this behaviour happens only when the database is hit after a long time say around couple of hours.

---- function to connect to sybase DB ---
function connect() {
if ( 0 == $this->Link_ID ) {
$this->Link_ID=sybase_pconnect(
$this->Host,
$this->User,
$this->Password);
if (!($this->Link_ID)) {
$this->halt("Link-ID == false, pconnect failed");
}
if(!sybase_select_db(
$this->Database, $this->Link_ID))
{
$this->halt("cannot use database ".$this->Database);
}
}
}

-------------

thanks is advance

-Badshah