Hi,

I'm a newbie on ASP with databases, and I'm trying to write a record to a 
database with fields on a web form to fields on that database.

After I hit the submit button, I get this error:

ADODB.Recordset error '800a0cb3'
Object or provider is not capable of performing requested operation.


I should note that the Access Database is still empty, with no records on 
it, I'm trying this on a Windows NT 4 Workstation PC with IIS 4 installed 
on it, and this is the sample of the code I'm using to try to write the 
record to the database.
Am I missing something?, what am I doing wrong? ... please I need help 
deperately. My job depends on it.
 THANx, here's the code:

 where "REQUEST" is the name of the Table and SUPPORT my DSN
--------------------------
   Dim RS
   Set RS=Server.CreateObject("ADODB.Recordset")
   RS.Open "request", "DSN=support"

   'Get fields from Web Form ---------------

   RS.AddNew
   RS.Fields("nAnt") = Request.Form("frmAnt")
   RS.Fields("UsrName") = Request.Form("frmName")
   RS.Fileds("UsrDept") = Request.Form("frmDept")
   RS.Fields("Problem") = Request.Form("frmProblem")
   RS.Update

Here is part of a note that I sent to someone who was probably in
the same boat as you...


The default recordset type is "read-only, forward-only".  Add
these statements:

	rs.CursorType=3  'Static cursor
	rs.LockType=3    ' Optimistic lock

That should do it.  The first property defines a recordset as one
that will allow updates (there are others, but for your purposes
this should be sufficient) and the second allows writing to the
recordset (among other things).

Larry Woods - MCSD, MCT



> -----Original Message-----
> From: Omar Esquivel [mailto:omare@u...]
> Sent: Friday, July 19, 2002 10:01 PM
> To: Access ASP
> Subject: [access_asp] Help! -- I get error '800a0cb3'
>
>
>
> Hi,
>
> I'm a newbie on ASP with databases, and I'm trying to
> write a record to a
> database with fields on a web form to fields on that database.
>
> After I hit the submit button, I get this error:
>
> ADODB.Recordset error '800a0cb3'
> Object or provider is not capable of performing
> requested operation.
>
>
> I should note that the Access Database is still empty,
> with no records on
> it, I'm trying this on a Windows NT 4 Workstation PC
> with IIS 4 installed
> on it, and this is the sample of the code I'm using to
> try to write the
> record to the database.
> Am I missing something?, what am I doing wrong? ...
> please I need help
> deperately. My job depends on it.
>  THANx, here's the code:
>
>  where "REQUEST" is the name of the Table and SUPPORT my DSN
> --------------------------
>    Dim RS
>    Set RS=Server.CreateObject("ADODB.Recordset")
>    RS.Open "request", "DSN=support"
>
>    'Get fields from Web Form ---------------
>
>    RS.AddNew
>    RS.Fields("nAnt") = Request.Form("frmAnt")
>    RS.Fields("UsrName") = Request.Form("frmName")
>    RS.Fileds("UsrDept") = Request.Form("frmDept")
>    RS.Fields("Problem") = Request.Form("frmProblem")
>    RS.Update
>
>
>