Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CursorLocation

Status
Not open for further replies.
arpan

arpan

Programmer
Oct 16, 2002
336
IN
What are the 2 CursorLocations - adUseServer & adUseClient used for? Are there any advantages/disadvantages of using one over the other? I have noticed that ASP sites which show examples of paging recordsets exclusively mention to use the adUseClient CursorLocation. Why so? Won't paging work if adUseServer is used instead of adUseClient? Also I have seen that irrespective of whether the CursorLocation is specified as adUseServer or adUseClient (or even if the CursorLocation property is not at all specified), it doesn't make difference in the data retrieval. Then what for should the CursorLocation property be used?

Thanks,

Arpan
 
Status
Not open for further replies.

Similar threads

spicysudhi
  • Locked
  • Question
CursorLocation and CLOB datatype
Replies
0
Views
18
spicysudhi
spicysudhi
dirkg
  • Locked
  • Question
Performance difference between CursorLocation=adUseClient and GetRows?
Replies
4
Views
71
Tarwn
Tarwn

Part and Inventory Search

Sponsor

Back
Top