Error message When trying to add record to database... 1

[DaiDreamer]

Hi!

I get this error message when I try and add my record to the database:

ADODB.Recordset error '800a0cb3'

The operation requested by the application is not supported by the provider.

/bureauofminere/frdocinvetory/NewAdded.asp, line 216


Here's the line of code the error is talking about:


set ADDconn = server.createobject("ADODB.Connection&quot
ADDconn.Open "DSN=SuretyDNS"
Session.timeout = 15
'Set Session("MyDB_conn&quot = ADDconn
response.write "addtodatabase"
Set RsAdd = server.CreateObject("ADODB.Recordset&quot
Set RsAdd.ActiveConnection = ADDconn
RsAdd.Open "InventoryOfSuretyDocuments"
response.write rsadd.fields("Section Name&quot

For counter = 1 to count
Select case Counter

case 1

RsAdd.AddNew 'error here
RsAdd.Fields("Section Name&quot= section1
RsAdd.Fields("Date of Requirement&quot=DateofRequire1
DocType1=request.form("BRDocType1&quot


Thanks!

DaiDreamer

 

[link9]

You need to set a writeable lockType to your recordset. The info you need (along with some other good stuff for you) is located here.

faq333-618


paul