Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem with XML template query

Status
Not open for further replies.

snvanvl

Programmer
Aug 14, 2001
1
CA
I'm having a major problem using a template to run a stored procedure!
I've created the Virtual Directory "xmltest" through IIS Manager for SQL Server. The location is c:\inetpub\xmltest\.

I've also created a Virtual Name "queries" as a template type with the same path listed above (and have checked the "allow template queries" box).

I can run the stored procedure through the following URL query (BUT I cannot run it as a template query using this URL (
The file test.xml is at c:\inetpub\xmltest\test.xml and contains the following code:

<?xml version='1.0' ?>
<root xmlns:sql=&quot;urn:schemas-microsoft-com:xml-sql&quot;>
<sql:query>
EXECUTE sp_test
</sql:query>
</root>

I have another server that is not having a problem running template queries, but I have tried everything I know of to get my new server working and now I'm stuck!
Any ideas??
Any help will be GREATLY appreciated!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top