#45756 [Opn]: Query is executed on wrong server (resource). Bug with global resource scope?

 ID:               45756
 User updated by:  jochem dot blok at fasterforward dot nl
 Reported By:      jochem dot blok at fasterforward dot nl
 Status:           Open
 Bug Type:         MSSQL related
 Operating System: Debian
 PHP Version:      5.2.6
 New Comment:

Btw. FreeTDS is used described in the manual:
http://nl2.php.net/manual/en/mssql.setup.php


Previous Comments:
------------------------------------------------------------------------

[2008-08-08 07:18:08] jochem dot blok at fasterforward dot nl

Description:
------------
See reproduce code. The query is executed 2 times on resource $r2.

Reproduce code:
---------------
$r1 = mssql_connect('my_server', 'my_user', 'my_pass');
mssql_select_db('database_1', $r1);

$r2 = mssql_connect('my_server', 'my_user', 'my_pass');
mssql_select_db('database_2', $r2);

$sSql = 'select count(*) as total from my_table';

$rRes1 = mssql_query($sSql, $r1);
$oRow1 = mssql_fetch_object($rRes1);
echo '1:   '.$oRow1->total.'<br>';

$rRes2 = mssql_query($sSql, $r2);
$oRow2 = mssql_fetch_object($rRes2);
echo '2:   '.$oRow2->total.'<br>';

Expected result:
----------------
Different total.

Actual result:
--------------
Same total.


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


-- 
Edit this bug report at http://bugs.php.net/?id=45756&edit=1