adUseClient or adUseServer

[pradeep_p43]

we use either adUseClient or adUseServer.
Can anyone tell me how does it affect the resources and when we will really feel the difference...
please...

[seemad]

I have not tried this out. But this is what i know.
1) We have the concept of RDS in ADO.
By using a with server-side cursor
disassociated Recordset objects cannot be simulated .

2) If the CursorLocation property is set to adUseClient to open a Recordset, the UnderlyingValue property on Field
objects is not available in the returned Recordset object,
This is the explanation of the underlying property:
"Use the UnderlyingValue property to return the current field value from the database. The field value in the UnderlyingValue property is the value that is visible to your transaction and may be the result of a recent update by another transaction. This may differ from the
OriginalValue property, which reflects the value that was originally returned to the Recordset."
Refer to the MSDN for more details.

[pradeep_p43]

thanks for ur reply...
actually i have got theoretical knowledge of the same...but in practical point of view i am not so clear...like which one os better or in what condition which one is to be used...
if posssible please make it clear..