recordset problem

Results 1 to 2 of 2

Thread: recordset problem

  1. #1
    Join Date
    Dec 1969

    Default recordset problem

    ADODB.Recordset error &#039 800a0cb3&#039 <BR><BR>The operation requested by the application is not supported by the provider. <BR><BR>/flash/newwork/login.asp, line 24 <BR><BR>this happens when i tried to:<BR><BR>set connect = server.CreateObject("Adodb.connection")<BR> connect.Open "webweb"<BR> set onmenu = server.CreateObject("Adodb.recordset")<BR> query = "select * from password"<BR> onmenu.Open query, connect, adlockoptimistic<BR> onmenu.AddNew<BR>the error refers to the line: onmenu.addnew<BR>what can be the problem? i tried to figure out why with no avail. please help<BR>

  2. #2
    icabod Guest

    Default RE: recordset problem

    I think you may need to add a cursor type (I would use adOpenKeyset for this).<BR><BR>onmenu.Open query, connect, adOpenKeyset, adlockoptimistic<BR><BR>Then I think it should let you use AddNew Method.<BR><BR><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