All,
In a client/sever application the application calls a stored procedure that returns multiple large result sets.If I want the application to process all of the result sets that are returned,
which properties of the ADO recordset should I set?

I have read that a client side cursor is needed to process multiple recordsets. However in MSDN for the NextRecordset method it states..Remote Data Service Usage The NextRecordset method is not available on a client-side Recordset object.

This seem to contradict the above, i.e. using
CursorLocation as adUseClient and any cursor type for processing multiple recordsets.

Can you please help

Viji