Error w/ Recordset AddNew Method

Results 1 to 2 of 2

Thread: Error w/ Recordset AddNew Method

  1. #1
    Join Date
    Dec 1969

    Default Error w/ Recordset AddNew Method

    I&#039m trying to perform a simple insert using the recordset AddNew method on an Oracle database. I got an ADODB.recordset error &#039 800a0cb3&#039 indicating that "The operation requested by the application is not supported by the provider." I had thought these methods worked with any ODBC database including Oracle. Please let me know if you have any insight. Thanks!

  2. #2
    Join Date
    Dec 1969

    Default RE: Error w/ Recordset AddNew Method

    I used to get the same error a lot of timesand someone told me it might have to do with the DSN connection so now I use connectionless connection, take a look at the following code for adding a record in oracle and see if it helps:<BR>&#060;% <BR> dim connect, myclass, qry, varname<BR> set connect = server.createobject("adodb.connection")<BR> "driver={microsoft odbc for oracle}; server= yourserver; uid=oracleuserid; pwd="""<BR> on error resume next<BR> <BR> set myclass = server.createobject("adodb.recordset")<BR> "customer", connect, adopendynamic, adlockoptimistic<BR> <BR> myclass.addnew<BR> myclass("seq_num") = request("seq_num")<BR> if request("refcode") = "" then<BR> myclass("refcode") = "0"<BR> else<BR> myclass("refcode") = request("refcode")<BR> end if<BR> if request("cmpgdesc") = "" then<BR> myclass("cmpgdesc") = "NA"<BR> else<BR> myclass("cmpgdesc") = request("cmpgdesc")<BR> end if<BR> myclass("existing") = request("existing")<BR> if request("acnum") = "" then<BR> myclass("acnum") = "NA"<BR> else<BR> myclass("acnum") = request("acnum")<BR> end if<BR> myclass("fname") = request("fname")<BR> myclass("lname") = request("lname")<BR> myclass("company") = request("company")<BR> myclass("title") = request("title")<BR> myclass("phone") = request("phone")<BR> if request("extn") = "" then<BR> myclass("extn") = "00"<BR> else<BR> myclass("extn") = request("extn")<BR> end if<BR> myclass("email") = request("email")<BR> myclass("fax") = request("fax")<BR> myclass("add1") = request("add1")<BR> myclass("add2") = request("add2")<BR> myclass("city") = request("city")<BR> myclass("state") = request("state")<BR> myclass("zip") = request("zip")<BR> myclass("country") = request("country")<BR> myclass("salesrep") = request("salesrep")<BR> myclass("custrep") = request("custrep")<BR> myclass("comments") = request("comments")<BR> myclass.update<BR> <BR> <BR> if err.number = 0 then %&#062;<BR>&#060;font size="5"&#062;<BR><BR>&#060;p align="center"&#062;New customer has been added. Please enter your email and click &#060;b&#062;Send<BR>Mail&#060;/b&#062;&#060;/font&#062;&#060;/p&#062;<BR>

Posting Permissions

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