800a0cb3 current recordset does not support updating

Open str FBSQL, obj Conn, 3,3,1 Bob Barrows -- Microsoft MVP -- ASP/ASP. The email account listed in my From header is my spam trap, so I don't check it very often. Do you have Query Analyzer (part of the SQL Server client tools)?You will get a quicker response by posting to the newsgroup. If so, run this sql statement: SELECT 'SQL Server ' CAST(SERVERPROPERTY('productversion') AS VARCHAR) ' - ' CAST(SERVERPROPERTY('productlevel') AS VARCHAR) ' (' CAST(SERVERPROPERTY('edition') AS VARCHAR) ')' If not, open a recordset on it in an asp page and look at the result.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.

800a0cb3 current recordset does not support updating-42

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

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.

Do you have Query Analyzer (part of the SQL Server client tools)?

If so, run this sql statement: SELECT 'SQL Server ' CAST(SERVERPROPERTY('productversion') AS VARCHAR) ' - ' CAST(SERVERPROPERTY('productlevel') AS VARCHAR) ' (' CAST(SERVERPROPERTY('edition') AS VARCHAR) ')' If not, open a recordset on it in an asp page and look at the result.

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.

IF there is a better way, I am more than happy to do it that way.

Well, I pointed you at an article that showed a few better ways.

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

Tags: , ,