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 ...");
for($i=1;odbc_fetch_row($res);$i++)
{
$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
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q143032
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
win32).
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
