Web Wiz Forums - Cursor Conflict in new

Print Page | Close Window

Cursor Conflict in new_post.asp

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=22330
Printed Date: 08 April 2026 at 9:48am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Cursor Conflict in new_post.asp

Posted By: jpwalters
Subject: Cursor Conflict in new_post.asp
Date Posted: 03 January 2007 at 8:16pm

Hi Borg!

-2147217885 "Cursor Operation Conflict" kept occuring on save_new_post_data in new_post.asp. No one could post new messages.

I'm not quite sure why this error started popping up, but I my initial guess was that "no count" was unchecked in the SQL Server Configuration (Connections). This was not the case. It was checked as being on, so my search continued....

Based on some knowledgebase articles, it seems like the server might be using a server-side cursor instead of a client side cursor, yikes!

So after some testing I added specific code to set the cursor type to client. (See Below)

Ultimately I added to new_post.asp as an experiment:

With rsCommon

.CursorLocation = 3

'Set the cursor type property of the record set to Dynamic so we can navigate through the record set
.CursorType = 2

...

It fixed the problem!

Then I looked at setting this globally in the database_connection.asp page, which also seems to work:

adoCon.connectionstring = strCon
adoCon.CursorLocation = 3

Any thoughts on what may have happened?

Thanks,

Jason Walters

-------------
Jason Walters