RE: [PHP-DB] ODBC problem in 4.2.0

I'd recommend finding a hosting service that would be more careful about making upgrades. There seems to be some problems with ODBC in 4.2 and I have yet to hear of a work around, especially not one you can implement if you don't handle your own server. I feel your pain man! Fortunately for me I can just stay at 4.1.1 until there's a release that works. <>< Ryan -----Original Message----- From: Mihai Tache [mailto:tache2@xnet.ro] Sent: Monday, April 29, 2002 7:11 PM To: php-db@lists.php.net Subject: [PHP-DB] ODBC problem in 4.2.0 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