note 63642 deleted from function.odbc-free-result by bjori
| From: | bjori@php.net | Date: | Mon, 27 Mar 2006 09:39:18 +0000 |
| Subject: | note 63642 deleted from function.odbc-free-result by bjori | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-106701@lists.php.net to get a copy of this message | ||
Note Submitter: jubal At Metahelp .c o. nz
Reason: in docs
----
"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