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:[EMAIL PROTECTED]]
Sent: Monday, April 29, 2002 7:11 PM
To: [EMAIL PROTECTED]
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


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

Reply via email to