Bug #17305: Handle multiple connection in SQL Server
| From: | vania at fe dot up dot pt | Date: | Sat, 18 May 2002 12:16:53 +0000 |
| Subject: | Bug #17305: Handle multiple connection in SQL Server | ||
| Groups: | php.pear.dev | ||
| Request: | Send a blank email to pear-dev+get-6213@lists.php.net to get a copy of this message | ||
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.
--
Edit bug report at http://bugs.php.net/?id=17305&edit=1
--
Fixed in CVS: http://bugs.php.net/fix.php?id=17305&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=17305&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=17305&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=17305&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=17305&r=support
Expected behavior: http://bugs.php.net/fix.php?id=17305&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=17305&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=17305&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=17305&r=globals