Microsoft Cursor Engine error '80020009'

[AgentM]

Can anybody tell me the meaning of this error.

Microsoft Cursor Engine error '80020009'
Multiple-step operation generated errors. Check each status value. ?

It happens when the recordset is displayed in a table.
It is happeningt to one particular query/search condition.

Any help highly appreciated.

 

[Niv3k]

I have gotten this error when two users are viewing the same record on a dynamic recordset and one updates the record, and another just moves the cursor. Maybe force the recordset to be static?

Kevin

 

[AgentM]

Thank you for the response
Well, I open the recordset as static...
Code:
Set rs = server.createObject("adodb.recordset&quot
rs.cursorlocation= adUseClient
rs.open sql,conn,adOpenStatic,adopenReadonly,adcmdtext

Can I make it static in any other way?

Thank you

 

[Niv3k]

According to the following link, do you have any text/memo fields in the table you are reading??? If so, you might want to re-create the table and put those fields all the way to the right of all the other fields in your table...

http://support.microsoft.com/support/kb/articles/Q175/2/39.ASP

 

[AgentM]

No, I don't have any memo fields. I did check that page earlier, but didn't help me much
I am using Oracle, and a lot of RDS objects.
I wonder if that's the problem,
Because RDS DataControl is supposed to destroy itself once the page unloads. You don't have to explicitly set it to nothing.

Thanks for the response.

 

[AgentM]

I found the problem, it was the date field in Oracle,
I was inserting dates as to_date('" & tdate & "','mm/dd/yy')

where tdate= Formatdateteime(now,2)
Oracle inserts the date well but while retriving it thru ASP it crashes.
I have used Provider=MSDAORA.1 as my connection string.

Does anybody have any suggestions:
1. If I can use a different connection string

2. No matter which date format the user enters it should be converted into mm/dd/yyyy format. Is there a function that can do that.

Thank you

 

[Niv3k]

I'm not an Oracle guy, (SQL Server) but can you build a stored procedure or a function inside the database that converts a string of chars to a date, and use that value for your insert? and vice versa for retrieval?

Kevin

 

[AgentM]

Thank you, That sounds like a permanent solution..