ODBC problem in 4.2.0
| From: | Mihai Tache | Date: | Tue, 30 Apr 2002 01:11:23 +0000 |
| Subject: | ODBC problem in 4.2.0 | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-18880@lists.php.net to get a copy of this message | ||
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 ?