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.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net