Classic ASP Discussion - ASP Error: Optimistic concurrency check..

Print Page | Close Window

ASP Error: Optimistic concurrency check..

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=11566
Printed Date: 31 March 2026 at 3:01am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: ASP Error: Optimistic concurrency check..

Posted By: Gullanian
Subject: ASP Error: Optimistic concurrency check..
Date Posted: 17 August 2004 at 12:10pm

Hi guys,

Getting a strange error message when trying to run an update query.  I'm using a cursor type of 2, and locktype of 3.  It's just a simple update query on a record that definatly exists.

----------------------------------------------------
Microsoft OLE DB Provider for ODBC Drivers (0x80040E23)

[Microsoft][ODBC SQL Server Driver][SQL Server]

Optimistic concurrency check failed. The row was modified outside of this cursor.

C:\INETPUB\WWWROOT\E-CVS\HTDOCS\NEW\JSINCLUDES\../../tomEcv/includes/stats.asp, line 503
----------------------------------------------------

Looked up on Google, it's to do with cursor and locktypes, but I'm sure im using the correct ones!

Anyone know whats wrong?

Tom

Replies:

Posted By: dpyers
Date Posted: 17 August 2004 at 2:14pm

IIRC I think I saw this once when I tried to update a table with a join to another table. Both tables had to have an index, not just the first one.

-------------

Lead me not into temptation... I know the short cut, follow me.

Posted By: Gullanian
Date Posted: 17 August 2004 at 2:46pm

Not a join, simple update query. Just adding 1 to a counter. This error never occurs for any other query on the site.