Retrieving xml output from SQL server 2000

[Pipe2Path]

I am trying to run a stored procedure that outputs the results of the query in XML format, using FOR XML AUTO.

Now, on the visual basic 6 side, the adodb.recordset object obviously won't work to retrieve the recordset. What do I use?

Any sample code available?

Can anyone help?

Thanks.