Solved

Recordset Cursor Operation Conflict

Posted on 2002-04-08
4
416 Views
Last Modified: 2008-02-01
Hi

I've got a site where I have quite a few DB access commands.  Most commonly they are in the form:

objRecordset.Open strSQL, DB_CONNECTIONSTRING, adOpenKeyset, adLockPessimistic, adCmdText

I've been occasionally getting 'Recordset Cursor Operation Conflict asp errors'   Is this due to the adLockPessimistic parameter and the number of users in the system increasing?

Any suggustions?
0
Comment
Question by:bendecko
  • 2
  • 2
4 Comments
 
LVL 11

Expert Comment

by:thunderchicken
Comment Utility
You might try

Application.Lock

and

Application.Unlock
 before and after SQL Calls
0
 
LVL 1

Author Comment

by:bendecko
Comment Utility
Recordset Cursor Operation Conflict errors could be due to pessmistic locking?

What does the application lock actually do?  What happens if two processes try to lock a table at the same time - wouldn't i get the same problem?

Bendecko
0
 
LVL 11

Accepted Solution

by:
thunderchicken earned 50 total points
Comment Utility
Your right, i was thinking of something totally different.  I thought it had to do with the entire process itself, but it only has to do with application variables...

Have you tried doing something like...

...
cn.open DB_CONNECTIONSTRING
set rs = cn.execute(strSQL)
...
0
 
LVL 1

Author Comment

by:bendecko
Comment Utility
Having a bit of a clean up of <unlocked questions>

This would almost certainly work I now know to use the connection object for INSERTS and UPDATES and leave the recordset for SELECTS

thanks

0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
This video discusses moving either the default database or any database to a new volume.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now