Solved

Recordset Cursor Operation Conflict

Posted on 2002-04-08
4
420 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
ID: 6926293
You might try

Application.Lock

and

Application.Unlock
 before and after SQL Calls
0
 
LVL 1

Author Comment

by:bendecko
ID: 6926886
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
ID: 6926908
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
ID: 7080237
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Dreamweaver server behavior gone 6 145
Summernote and form validation 10 180
ASP CDO - Limiting Connections 3 59
Time Conversions...both ways 2 16
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
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 shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

840 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