rs.Update error for Oracle

Results 1 to 2 of 2

Thread: rs.Update error for Oracle

  1. #1
    Join Date
    Dec 1969

    Default rs.Update error for Oracle

    I&#039;m connecting to Oracle using OLEDB (Provider=MSDAORA).<BR>My recordset is created as below<BR> set rsForm = Server.CreateObject("ADODB.Recordset")<BR> rsForm.Open sTableName, db, adOpenKeyset, adLockOptimistic, adCmdTable<BR> rsForm.AddNew<BR><BR>When trying to use rsForm.addnew I get the following error:<BR>ADODB.Recordset error &#039;800a0cb3&#039; <BR>Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.<BR><BR>Can I use all the ADODB Recordset methods (MoveFirst, MoveLast, Update etc) with Oracle or not? If I can then what do I need to change to get it to work?<BR><BR>Thanks Teri

  2. #2
    Join Date
    Dec 1969

    Default RE: rs.Update error for Oracle

    The best way to insert new records into a table is to use INSERT.

Posting Permissions

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