ADODB.Recordset (0x800A0CB3)

Results 1 to 2 of 2

Thread: ADODB.Recordset (0x800A0CB3)

  1. #1
    Join Date
    Dec 1969

    Default ADODB.Recordset (0x800A0CB3)

    ADODB.Recordset (0x800A0CB3)<BR>Object or provider is not capable of performing requested operation.<BR><BR>What Does This Error Mean ?<BR><BR>Its in relation to this code:<BR><BR>&#060;!--#include file=""--&#062;<BR>&#060;%<BR>Dim strsql, strcookie, strpass<BR><BR>strCookie = Request.Cookies("ID")<BR>strPass = Request.Form("Pass")<BR><BR>qs=request.querystring ("id")<BR>if qs&#060;&#062;"" then<BR><BR>set myconn=server.createobject("adodb.connection")<BR> set rspass=server.createobject("adodb.recordset")<BR>m connect<BR><BR> "SELECT ID,Pass FROM Members where id=" & qs & "",myconn<BR><BR>rspass("pass") = strPass<BR><BR>rspass.update<BR><BR>end if<BR>%&#062;<BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default You are opening RS read-only... of course you can&#039;t make any changes to it.<BR><BR>You are doing:<BR><BR> "SELECT ID,Pass FROM Members where id=" & qs & "",myconn<BR><BR>[and what is the & "" in there for, by the way?]<BR><BR>But since you don&#039;t specify an OpenMode or a LockMode, you are getting adOpenForwardOnly and adLockReadOnly by default.<BR><BR>Check out the MSDN docs for ADODB.RecordSet.Open to see what you should be using. (adOpenKeyset and adLockPessimistic seem most probable.)<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