800a0cb3 current recordset does not support updating


04-Jun-2017 21:34

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 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. 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. I am moving my webserver from NT4 using SQL to win2003 using SQL 2003 No such thing. 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" ADODB.

The fourth sin: retrieving all the records from your database table when you really intend to add records: potentially a massive waste of resources (actually, your use of a keyset cursor did mitigate this somewhat - but that is still the inappropriate cursor type for this task).

Since you only intend to add records, you should retrieve an empty recordset.

Here's the code: [Code] Dim o Conn Dim o Rs Dim qry, connectstr, s DSNDir Dim dsn_name, Avtionvar Dim SQLstmt Dim Note Field, Note, o Rs_num Rows Actionvar=Request. Open "tbl Biographical Data", connectstr IF Actionvar="add" THEN o Rs.And the third cardinal sin: revealing your sa password on the internet!!!



Discuss why the students like to read mysteries and what they like about the Cam Jansen myseries.… continue reading »


Read more

During the course of the scene, they share a kiss that Waverly initiates, but Rosita returns.… continue reading »


Read more

According to a source, the former couple's travel schedules played a factor and RPattz is the one who pulled the plug and initiated everything.… continue reading »


Read more

However, he was put through to the quarter-final by the public vote.… continue reading »


Read more

I am a professional matchmaker, and not all that long ago, I got myself hitched... I had been in the dating business for over 15 years, first with my matchmaking business, Samantha's Table, that I founded over 16 years ago and then with my dating app, The Dating Lounge that I founded this year.… continue reading »


Read more