Adding records via ADO-stupid question

[MikeT]

(assume conn = the database connection)
set rs = server.CreateObject("adodb.recordset&quot
rs.Open "myTable", conn
rs.AddNew
rs("Date&quot = Request.Form("datDate&quot
rs.update
rs.close

I get this error:
ADODB.Recordset error '800a0cb3'
Object or provider is not capable of performing requested operation.
(points to rs.addnew line)

wtf?

 

[MikeT]

figured it out:
include the adovbs.inc file, and
rs.Open "myTable", conn, adOpenKeyset,adLockOptimistic

but why is this?

 

[JohnYingling]

What database type?
If Oracle, then MSDN search of "ADO ERROR 800A0CB3" gives

When you perform updates or add new records to an Oracle database by using Microsoft ActiveX Data Objects (ADO), the following error may occur: 

ADODB.Recordset (0x800A0CB3)
Object or provider is not capable of performing requested operation. 

CAUSE
This error message is generated because the Oracle OLE DB Provider does not support server-side updates. 

RESOLUTION
You must use client-side cursors to perform updates against an Oracle database by using the Microsoft Oracle OLE DB Provider. To do this, before opening the recordset, specify the CursorLocation property to equal adUseClient (or the number "3"). 

STATUS
This behavior is by design.

http://WWW.VBCompare.Com

 

[MikeT]

Actually its an Access db, but the resolution seems to be the same. Thanks for the reply!