|
| I've used this SQLXML 3.0 utility called "Configure IIS Support" to set
up a virtual directory on my IIS 6.0 Webserver. It connects to a SQL
Server 2000 database and I've got a template query that executes a
stored procedure. Inside the sproc, I have a FOR XML AUTO clause on my
SELECT statement. This all works nicely and feeds an XML document to
some client side Javascript code where I create an XMLHTTP object and
then parse the xmlDocument.
Now I want to do the same sort of thing but my data is contained in a
SQL Server 2005 database. I've tried following the same steps using the
SQLXML 3.0 utility but I get a basic "file not found" error. I know
there are lots of XML improvements in the 2005 version and I look
forward to learning all about them someday.
But for now, I'm wondering if someone could help me understand what
might be wrong on this. Here is my URL:
http://localhost/ITMOLenderView/tem...pLenderInfo.xml
ERROR: 404 Not Found
HResult: 0x80070002
Source: Microsoft SQL isapi extension
Description: File not found
At the physical location above, I have the following content in file
spLenderInfo.xml:
<?xml version="1.0" encoding="UTF-8"?>
<LenderInfo xmlns:sql="urn:schemas-microsoft-com:xml-sql">
<sql:header>
<sql:param name="NamePrefix"></sql:param>
</sql:header>
<sql:query>
EXECUTE dbo.spGetLenders @NamePrefix
</sql:query>
</LenderInfo>
---- Is there something special to do on SQL 2005 instance to support
this?
Here is the URL that works fine connecting me to SQL 2000:
http://localhost/FLAS/template/spGetAwardsV2.xml
Contents follow below:
<?xml version="1.0" encoding="UTF-8"?>
<flasInfo xmlns:sql="urn:schemas-microsoft-com:xml-sql">
<sql:header>
<sql:param name="AreaID"></sql:param>
<sql:param name="Scramble"></sql:param>
</sql:header>
<sql:query>
EXECUTE dbo.FLAS_List_Awards_V1 @AreaID, @Scramble
</sql:query>
</flasInfo>
|
|