Adodb recordset error 800a0cb3 current recordset does not support updating

Rated 4.44/5 based on 762 customer reviews

Recordset error '800a0cb3' Current Recordset does not support bookmarks. Recordset error '800a0cb3' Current Recordset does not support bookmarks. Recordset error '800a0cb3' Current Recordset does not support bookmarks. If you are using a recordset for paging, you may want to consider one of the more efficient methods talked about in this article: If you are really married to utilizing the absolutepage property this way, we are going to need more information: -what provder are you using?

This may be a limitation of the provider or of the selected cursortype. This may be a limitation of the provider or of the selected cursortype. This may be a limitation of the provider or of the selected cursortype. Well, you probably have a different version of ADO (MDAC) on the new machine whose OLE DB provider is more strict about the cursor types that support bookmarks. -what cursortype are you requesting for the recordset? (do a response.write rs.cursortype after opening the recordset) Bob Barrows -- Microsoft MVP - ASP/ASP. This email account is my spam trap so I don't check it very often.

I have no explanation for this behavior if you are using SQL 2000. If you actually have SQL 2005, then there may be an issue with the SQLOLEDB provider.

You may have better luck with the new SQLNCLI provider. Connection String = "Provider=SQLNCLI;" _ & "Server = MAILSVR ;" _ & "Database=TTSI;" _ & "User ID=xxxx;" _ & "Data Type Compatibility=80;" _ & "Password=xxxxx;" Of course, regardless of the version, you can force ADO to construct a static cursor by specifying a client-side cursor: set rs FBills=Create Object("adodb.recordset") rs FBills.cursorlocation = 3 ' ad Use Client rs FBills. The version of SQL Server does not depend on the box on which it is running.

Recordset error '800a0cb3' Current Recordset does not support updating.

This may be a limitation of the provider, or of the selected locktype.

Well, I pointed you at an article that showed a few better ways.In order to answer that question, YOU need to provide the answer to ALL the other questions I asked in my previous reply. I asked 4 questions in my previous post and you answered one of them. :-) ) In addition, you will need to show the code used to open your connection (including the connection string - you can replace the username and password with xxxx if you aren't using integrated authentication to connect) and the code used to create and open the recordset.If you're dealing with a lot of user inputs and a long sql statement, you can snip that out because it probably isn't relevant. Recordset error '800a0cb3' Current Recordset does not support bookmarks. If you are using a recordset for paging, you may want to consider one of the more efficient methods talked about in this article: If you are really married to utilizing the absolutepage property this way, we are going to need more information: -what provder are you using?/devag/new Proj Save.asp, line 321 sql OCF = "SELECT * FROM DA_Other CFacilities" set rst OCF = Create Object("ADODB. Open sql OCF, "Provider=SQLOLEDB.1; Persist Security Info=False; User ID=sa;[email protected]; Initial Catalog=GIS; Data Source=172.16.4.180",1,1 'x = 1 For i = 1 to (T-1) If request.form("Name" & i) "" Then **line 321 rst OCF.addnew rst OCF("Proj Id") = rsid("Proj ID") rst OCF("Fin Id") = rs Fid("ID") rst OCF("IName") = request.form("Name" & x) rst OCF("Acc Type") = request.form("AType" & x) rst OCF("Acc No") = request.form("ANo" & x) rst OCF.updatebatch End If 'x = x 1 Next Any help and/or suggestions highly appreciated. Recordset error '800a0cb3' My comments will be interspersed with your text, so make sure you read through to the end.Hopefully you won't get defensive and think I'm denigrating your abilities: no matter how it appears, everything that follows should be considered constructive criticism. Well, I would consider this to be a blessing in disguise: recordsets should not be used for updating in ASP apps.

Leave a Reply