#36639 [Opn]: mssql_select_db(); didnt work for multiple connection

ID: 36639 User updated by: Satria at dreamweb dot co dot id Reported By: Satria at dreamweb dot co dot id Status: Open Bug Type: MSSQL related Operating System: NT2K PHP Version: 5.1.2 New Comment: there is another solutions for this (if this were MySQL Function) force mysql_connect to open newLink but http://php.net/mssql_connect didnt have that parameter on the connect Option Previous Comments: ------------------------------------------------------------------------ [2006-03-07 06:59:11] Satria at dreamweb dot co dot id Description: ------------ mssql_select_db() also override Used Database on the another Connection Reproduce code: --------------- $sqlLink1=mssql_connect($host,$user,$pass); $SecondLINK=mssql_connect($host,$user,$pass); /*Yes, both connection on same Machine*/ mssql_select_db('db1',$sqlLink1); /*Until here, still no problem*/ mssql_select_db('db2', $SecondLINK); //Second time DB Select also will override $sqlLink1, is this Bugs? or... its what should it be ? Expected result: ---------------- mssql_select_db() only affected on the $param2 connection Actual result: -------------- - ------------------------------------------------------------------------ [2006-03-07 05:10:18] Satria at dreamweb dot co dot id Description: ------------ mssql_select_db() also override Used Database on the another Connection Reproduce code: --------------- $sqlLink1=mssql_connect($host,$user,$pass); $SecondLINK=mssql_connect($host,$user,$pass); /*Yes, both connection on same Machine*/ mssql_select_db('db1',$sqlLink1); /*Until here, still no problem*/ mssql_select_db('db2', $SecondLINK); //Second time DB Select also will override $sqlLink1, is this Bugs? or... its what should it be ? Expected result: ---------------- mssql_select_db() only affected on the $param2 connection Actual result: -------------- - ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=36639&edit=1