note 63642 added to function.odbc-free-result

"PHP Warning: odbc_do(): SQL error: [unixODBC][FreeTDS][SQL Server]Invalid cursor state, SQL state 24000 in SQLExecDirect in /var/www/html/mocks/header.html on line 23" I was getting the above error when connecting using php+unixODBC+FreeTDS to MSSQL 2000, if i wasnt using a while loop to collect the results [i.e. using $patient = odbc_fetch_array($patientResult);] Turns out if I added the line odbc_free_result($patientResult); things start working. Google was no help to me, but i hope if u'll find this if you encounter the same problem. Jubal ---- Server IP: 66.163.161.117 Probable Submitter: 202.37.75.101 (proxied: 172.20.4.115) ---- X-Spam-Status: No, hits=3.1 required=5.0 tests=DATE_MISSING,FROM_NO_LOWER autolearn=no version=2.64 ---- Manual Page -- http://www.php.net/manual/en/function.odbc-free-result.php Edit -- http://master.php.net/note/edit/63642 Del: integrated -- http://master.php.net/note/delete/63642/integrated Del: useless -- http://master.php.net/note/delete/63642/useless Del: bad code -- http://master.php.net/note/delete/63642/bad+code Del: spam -- http://master.php.net/note/delete/63642/spam Del: non-english -- http://master.php.net/note/delete/63642/non-english Del: in docs -- http://master.php.net/note/delete/63642/in+docs Del: other reasons-- http://master.php.net/note/delete/63642 Reject -- http://master.php.net/note/reject/63642 Search -- http://master.php.net/manage/user-notes.php