Microsoft OLE DB Provider for ODBC Drivers error '80040e10'

[Rally2002]

Hi!

I sometimes (perhaps 2 out of 10 times) get the following error
message:

Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters.
Expected 1.

However, if I refresh the webpage the error disapears.

I use the following SQL query:

SELECT date, name, title, id FROM forum ORDER BY id DESC

After reading about the above error in this group, I learned that
"date" is a reserved keyword in Access, SQL and Jet.

My question is:

Could the usage of a reserved keyword generate the error? What's
puzzling me is the fact that the error only occurs once in a while and
that a simple refresh is enough to (temporarly) resolve the problem.
This kind of stochastic error seems very strange!!

/Rally2002

 

[tman138]

Usually this message is from an incorrectly defined field value in your query. However we have experienced ODBC timeouts with applications opened for longer than the default 1500 seconds defined in the ODBC timeout settings. If this is only happening after the app is opened for an extended period of time, try extending the ODBC timeout setting to 30000 seconds (8.33 hours)this should resolve the problem.