Adodb recordset error 800a0cb3 current recordset does not support updating adultporno
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.It replied with : SQL Server 8.00.760 - SP3 (Standard Edition) I haven't had a chance to go through and read the articls you suggested, but I plan to. OK, so you requested a static cursor (3=ad Open Static), and according to your last post, you actually got a forward-only cursor.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.SQL DML statements (UDATE, INSERT and DELETE) executed via stored procedures (given that you are using SQL Server) would be my choice. Source=172.16.4.180",1,1 This is part of your problem: you have just opened a keyset (completely unnecessary), read-only cursor.
IF there is a better way, I am more than happy to do it that way. Open "Provider=SQLOLEDB.1; Password=xxxxx; Persist Security Info=True; User ID=xxxx; Initial Catalog=TTSI; Data Source=MAILSVR" if txt PONumber = "" then str FBSQL = "SELECT * FROM TTSITracing WHERE " & str Which Company & " = " & str User ID & " AND (" & t Pickup Delivery & " Well, if you look that up at you will see that 0 translates to ad Open Forward Only, which according to the chart on this page: does not support ad Bookmark (bookmarks). What now needs to be explained is why you are getting a forward-only cursor, which I suspect is not intended (and which the same exact code on your NT4 box was not returning).
the rest is up to you :-) Here is the code you requested.: obj Conn.