rs.CursorLocation = adUseClient

when is use
  rs.CursorLocation = adUseClient
the asp browser hangs
why?
ninooAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PiNCommented:
Paste more of your code...
One explanation for the thing described above is that you try to retrieve huge masses of data. That will slow down when using client-side cursors.

PiN
0
amnhCommented:
In ASP there is no method of linking to a dll and reading the enumerated types or constants used within the dll.  Interdev works around this if you use microsoft's design time controls by duplicating the constants and enumerated in its script library.

If you are opening the recordset with out use of design time controls then you should define the constant adUseClient = 3 before opening the recordset.

The following may help you.
adUseClient =3
set rs = server.createobject("adodb.recordset")
rs.CursorLocation = adUseClient
rs.open strSQL, conn

strSQL and conn are your sql statement and ado connection

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
MoondancerCommented:
This question was awarded, but never cleared due to the JSP-500 errors of that time.  It was "stuck" against userID -1 versus the intended expert whom you awarded.  This corrects the problem and the expert will now receive these points; points verified.

Please click on your Member Profile and select "View Question History" to navigate through any open or locked questions you may have to update and finalize them.  If you are an EE Pro user, you can also choose Power Search to find all your open questions.

This is the Community Support link, if help is needed.  Also a question is posted there specific to these changes that apply to the experts here.  Also, I am including the link to our All Topics, since many new ones have recently been added.

http://www.experts-exchange.com/jsp/qList.jsp?ta=commspt
http://www.experts-exchange.com/jsp/zonesAll.jsp
 
Thank you,
Moondancer
Moderator @ Experts Exchange
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP

From novice to tech pro — start learning today.