ADODB.Field error '800a0cb3' - Current

Results 1 to 2 of 2

Thread: ADODB.Field error '800a0cb3' - Current

  1. #1
    Join Date
    Dec 1969

    Default ADODB.Field error '800a0cb3' - Current

    Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype<BR><BR>The error comes up when I actually try to update the record <BR> <BR> objRS.Fields("totalvisits").Value = iCount + 1<BR> objRS.Update<BR><BR>Could you please give some direction?<BR> <BR><BR>&#060;% response.buffer = true%&#062;<BR>&#060;%Session("MyCompass") = Request.ServerVariables("LOGON_USER")<BR>MyCompass = Session("MyCompass") <BR>Session("visit") ="" <BR>visit = Session("visit")<BR>%&#062;<BR>&#060;% Dim objConn, objRS, SQL, visit, icount<BR>%&#062;<BR><BR>&#060;% Function DBConnect (SQL)<BR> <BR>Set objConn = Server.CreateObject("ADODB.Connection")<BR> &#039;for a acces2000 db<BR> objConn.ConnectionString = "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & Server.MapPath("profile/profile.mdb") <BR>objConn.Open <BR><BR> &#039; Create record set and execute SQL command<BR> Set objRS = Server.CreateObject("ADODB.RecordSet")<BR> objRS.Open SQL, objConn, adOpenKeyset<BR>End Function %&#062;<BR><BR>&#060;% Function DBClose<BR> &#039;This function closes and destroys objects for the database. It<BR> &#039;should be called exactly once per page,<BR> objRS.Close<BR> objConn.Close<BR> <BR> Set objRS = Nothing<BR> Set objConn = Nothing<BR>End Function %&#062;<BR><BR>&#060;%<BR>if session("visit") ="" then<BR> DBConnect "SELECT * FROM profile WHERE NTUserID = &#039;" & MyCompass & "&#039;"<BR> iCount = objRS.Fields("totalvisits").Value<BR> objRS.Fields("totalvisits").Value = iCount + 1<BR> objRS.Update<BR> If objRS.EOF then<BR> DBClose<BR> Response.Redirect("profile/addprofile.asp")<BR> End if<BR>end if<BR> session("visit") = 1<BR><BR><BR>%&#062;

  2. #2
    Join Date
    Dec 1969

    Default try

    iCount =iCount+ 1 <BR>objRS.Fields("totalvisits")= iCount<BR>objRs.Update

Posting Permissions

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