When using the IIS SQL XML connector with a template such as with the
following:

<?xml version='1.0' encoding='utf-8'?>

<Inscrits xmlns:sql="urn:schemas-microsoft-com:xml-sql">
<sql:header>
<sqlaram name="EventID">
</sqlaram>
</sql:header>
<sql:query>
SELECT *
FROM dv_Inscrits
WHERE EventIDCode= @EventID
FOR XML RAW
</sql:query>
</Inscrits>
---------------------

I get something similiar to this:

<?xml version="1.0" encoding="utf-8" ?>
- <Inscrits xmlns:sql="urn:schemas-microsoft-com:xml-sql">
<row TeamId="17630" TeamName=.......

----------------------
If I try to attach a Gridview to this XML datasource I get a complaint from
VS that says that:

The data source for GridView with id 'GridView1' did not have any properties
or attributes from which to generate columns. Ensure that your data source
has content.
---------------------
If I open the file in Internet Explorer, or even Excel for that matter, it
works fine. I can see the data. If I save the XML to a file and remove the
xmlns:sql="urn:schemas-microsoft-com:xml-sql" portion of the XML provided by
the SQL XML connecter the form works.

What should I be doing either in the template or VS-basic to make this work?