RECORDSETS-Client side or Server side

[mickey_in]

Hi mates, How ya doing ?

I am just wondering when we give the CursorLocation
=adUseClient than what actually happens.

Is it something like, the recordset is created on clients' machine.
I mean the data which is stored in buffer is actually cache
on the clients' machine rather than using the server buffer.?

And if this is true, than it means recordsets are actually created on
client machine when dbserver throws all the data on the client machine
requested by the client rather than opening the recordset/caching the
data on its own machine.

The question does sound stupid but actually I am confused with
this. I request all the developers to post their views.

Thanks In advance...

Mickey.
_________________
[Mickey]

[administrator]

This article answers your questions:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dninvb00/html/ADORecordset.asp
_________________
Peter
ASP & ASP.NET Articles and Tutorials

[mickey_in]

Thanks a lot admin, It's a great help. I actually heard about the disconnected
recordsets but never knew the way to implement it. The article contains
a good information about how to create one and also it has clear the
doubts that I have in my mind regarding the adUseClient and adUseServer.

Thanks a lot bro...
_________________
[Mickey]