sp_OAMethod returning recordset

[shmiller]

I have a stored proc which uses sp_OAMethod to call a VB COM object and get data back. Currently my COM object puts the data in a 2D array and returns it as a variant. In my T-SQL, I'm able to get this data as a resultset. Is there a way that I could have my COM object return a disconnected ADO recordset instead of an array variant. I have tried using a table variable, a cursor, and a sql_variant as the return parameter in the sp_OAMethod call, but none of them work. Any ideas would be appreciated.
Thanks,
Shanti