I am using COM+ and have a wrapper layer for the ADO libraries that handle error handling and abstration etc.
I need to be able to pass disconnected recordsets that contain multiple resultsets back to my clients but you cannot disconnect a recordset if you want to call the RS.NextRecordset function.
Has anyone else got any ideas?
I was thinking of returning an array of disconnected recordsets back.
(Connecting to MS SQL Server 7)
