Problem with Execute XML Reader

Question

Hi,

 I have written a Stored Procedure in SQL Server 2008 which returns XML output using the FOR XML Clause in the Select statement. 

 When I execute the Stored Procedure from the DB Directly it gives me a perfect XML Output as desired. But when I am using it from my application it gives me an exception which says - "Invalid command sent to ExecuteXmlReader.  The command must return an Xml result."

I have used this in several other places and its working fine. But not here. 

Kindly help in this regard.

Shadaan.

Answer 1

Hi Shadaan,
Is it possible to put some code and stored procedure so that a solution can be provided ?

Thanks
PKR

Answer 2

Did you check whether the query is returning the xml with the xml declaration statement and also the root node?

Also you could a normal SqlDataReader instead of an XmlReader and retrieve. Since you are using the For XML keyword, it would always return valid xml.

---

Ganesh Ranganathan
[Please mark the post as answer if it answers your question]
blog.ganeshzone.net

Answer 3

Hi Shadaan,
It is a long time since the last reply, did you get useful information from above suggestions, or you still have any concern about this issue? Please let us know.

Thanks,

Eric

---

Please remember to mark helpful replies as answers and unmark them if they provide no help.