datingconsultancy com - 800a0cb3 current recordset does not support updating

the rest is up to you :-) Here is the code you requested.: obj Conn.

Open "Provider=SQLOLEDB.1; Password=xxxxx; Persist Security Info=True; User ID=xxxx; Initial Catalog=TTSI; Data Source=MAILSVR" OK, so you requested a static cursor (3=ad Open Static), and according to your last post, you actually got a forward-only cursor.

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

800a0cb3 current recordset does not support updating-44

800a0cb3 current recordset does not support updating Free adult web chat ipad

Open "pressrelease", obj Conn, ad Open Dynamic, ad Lock Optimistic ADODB.

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

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 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.

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

我申请了一个国外的空间,用88852.com的源码制作了一个网站,但是在是用过程中出现了: ADODB. Recordset error '800a0cb3' Current Recordset does not support updating.

I am moving my webserver from NT4 using SQL to win2003 using SQL 2003 I get the above error when my asp page does teh line: Rs.absolutepage = int Current Page I tested teh value of int Current page and teh value is 1. If you must reply off-line, then remove the "NO SPAM" -- Microsoft MVP -- ASP/ASP. The email account listed in my From header is my spam trap, so I don't check it very often.

You will get a quicker response by posting to the newsgroup.

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.

Tags: , ,