I had the same problem, working through ADO.

googling led me to this URL

http://sqlxml.org/faqs.aspx?faq=104

I changed my connection string from PROVIDER=SQLOLEDB to Driver={SQL Server} and the XML started coming out as valid XML text instead of binary garbage.