RE: [PEAR-DEV] Bug #17305: Handle multiple connection in SQL Serv er

Hi, It's strange, but now the script just can't show nothing... It's processing, processing and it gets timed out. I didn't change anything and now even with only one connection it doesn't work... I get this strange behaviour. Should I update all the PEAR dir tree? Vânia -----Original Message----- From: Tomas V.V.Cox [mailto:cox@idecnet.com] Sent: segunda-feira, 20 de Maio de 2002 13:14 To: vania@fe.up.pt Cc: pear-dev@lists.php.net Subject: Re: [PEAR-DEV] Bug #17305: Handle multiple connection in SQL Server Hi, Could you try this version if works as expected? Thanks, Tomas V.V.Cox vania@fe.up.pt wrote: > > From: vania@fe.up.pt > Operating system: Win 2000 > PHP version: 4.2.0 > PHP Bug Type: PEAR related > Bug description: Handle multiple connection in SQL Server > > It seems that DB.php cannot handle different connections for SQL Server. I > noticed that you fixed this for MySQL. > > In mysql.php you have this: > if ($dsninfo['database']) { > // fix to allow calls to different databases in > the same script > if (empty($GLOBALS['_DB_mysql_changed_database'])) { > $this->_changed_db = false; > if (!@mysql_select_db($dsninfo['database'], $conn)) { > return $this->raiseError(DB_ERROR_NODBSELECTED, null, > null, null, mysql_error($conn)); > } > } else { > $GLOBALS['_DB_mysql_changed_database'] = true; > $this->_changed_db = $dsninfo['database']; > } > } > > And in mssql.php it's only this: > > if ($dsninfo['database']) { > if (!@mssql_select_db($dsninfo['database'], $conn)) { > return $this->raiseError(DB_ERROR_NODBSELECTED, null, > null, null, mssql_get_last_message()); > } > } > > In my scripts I noticed that it handles only the last connection made and > ignores queries with the other objects created to access database.