This topic is locked

odbc_fetch_array()... SQL Error!

7/13/2007 3:07:10 AM
PHPRunner General questions
P
Paul author

Hi,
Suddenly i get this error, after had it running fine for a couple of mounth.

I havent done anything to it, but now i can´t even open the list page.

Can you give me a clue?
BR/Paul
Feltyp 2

Felbeskrivning odbc_fetch_array() [function.odbc-fetch-array]: SQL error: [Microsoft][ODBC Microsoft Access Driver]Invalid cursor position; no keyset defined , SQL state S1109 in SQLGetData

URL /Kontr_lake_list.php

Fel fil
\include\dbconnection.php

Fel linje 88

SQL fråga select top 20 [ID], [Datum], [Produkt], [Onskad_Lake], [Uppmatt_lake], [Avvikelse_lake], [Vikt_fore], [Vikt_efter], [Avvikelse_vikt], [Notering], [Sign], ((Vikt_efter - Vikt_fore) / Vikt_fore) * 100 as Insprutad_vikt From [Kontr_lake] ORDER BY [Datum] DESC

Solution This is a general error. It occurs when thereis an error in event code or in SQL.
Send your SQL or event code along with full error message to

J
Jane 7/13/2007

Paul,
it's difficult to tell you what's happening without seeing actual files.
Please publish your project on Demo Account and send to [email=support@xlinesoft.com]support@xlinesoft.com[/email] a URL to your pages along with instructions on reproducing this error.

I'll find what's wrong with your project inspecting it at Demo account site.