i work on a website that runs on php with MSSQL through ODBC.
until 4.2.0 everything was ok. but my hosting provider just upgraded to 4.2.0
the error message i get is :

SQL error: [Microsoft][ODBC SQL Server Driver]Connection is busy with results for 
another hstmt, SQL state S1000 in SQLExecDirect in ....

take the folowing code for example :

$res=odbc_exec($conn,"select * from ...");
        $res2=odbc_exec($conn,"select * from ....");

the first odbc query runs OK but i get the error at the second one and ONLY if the 
first one returned more than one row.
i even tried with 2 ODBC connections but doesn't work
MS has something to say about this at 
don't know if that is really the problem or not. i don't know how i can set ODBC (from 
php) to be synchronous anyway.
the fact is that the same scripts worked fine 6h ago on 4.1.1 and 4.0.6 (both on 
i'd go back to 4.1.1 but i'm forced to work with 4.2.0 as i said
is there something i can do except wait for 4.2.1 ?

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to