Object or provider not capable of performing reque

Results 1 to 2 of 2

Thread: Object or provider not capable of performing reque

  1. #1
    Join Date
    Dec 1969

    Default Object or provider not capable of performing reque

    Here&#039s the error:<BR><BR>ADODB.Recordset error &#039 800a0cb3&#039 <BR>Object or provider is not capable of performing requested operation. <BR><BR>Here&#039s the script:<BR><BR>set cnnSoftwareMatrix = server.CreateObject("adodb.connection")cnnSoftware Matrix.Open "dsn=SoftwareMatrixDB"<BR>set rstNewManufacturer = server.CreateObject("adodb.recordset")<BR>rstNewMa nufacturer.Open "tblManufacturer", cnnSoftwareMatrix<BR><BR>rstNewManufacturer.AddNew <BR><BR>rstNewManufacturer.Fields("ManufacturerNam e") = Request.Form("txtmanName")<BR><BR>rstNewManufactur er.Fields("Contact") = Request.Form("txtManContact")<BR><BR>rstNewManufac turer.Fields("Phone") = Request.Form("txtManPhone")<BR><BR>rstNewManufactu rer.Fields("StreetAddress") = Request.Form("txtManAddress1") & Request.Form("txtManAddress2")<BR><BR>rstNewManufa cturer.Fields("City") = Request.Form("txtManCity")<BR><BR>rstNewManufactur er.Fields("State") = Request.Form("cboManState")<BR><BR>rstNewManufactu rer.Fields("ZipCode") = Request.Form("txtManZip")<BR><BR>rstNewManufacture r.Fields("ManufacturerComments") = Request.Form("txaManComments")<BR><BR>rstNewManufa cturer.Update<BR><BR>I ran a validation script to check if the method is supported and it is. I am totally confused and frustrated so any help would be greatly appreciated. Thanks.

  2. #2
    jason Guest

    Default RE: Object or provider not capable of performing r

    you haven&#039t specified your recordset as updateable. adLockOptimistic is the constant you&#039re looking for

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts