rs.CursorLocation = adUseClient

when is use
  rs.CursorLocation = adUseClient
the asp browser hangs
why?
ninooAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
amnhConnect With a Mentor Commented:
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
 
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
 
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
All Courses

From novice to tech pro — start learning today.