I am using ADO to call a SQL Server stored procedure. This procedure returns 3 result sets. I need to get the third one. How do I do this?

I do not have the flexability to change the order of the result sets. I am working with an already existing database creating an add on. So that solution is out.

Are there any other techniques available to get to the other result sets?