• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 355
  • Last Modified:

SQL 2000/XML/XSL....error loading XSL stylesheet?#$%??

Hi, I'm trying to use XSL to format the XML output generated by SQL XML in IIS.

I pass a SQL command thru HTTP request.
ex) http://www.xyz.com/xml/sql=select * from tblProducts for xml auto&root=root

It displays the output the way I expect it to.

But when I try and use XSL stylesheet to format the output, IIS spits out the following error message. What am I doing wrong? and/or what am I missing?

ERROR: 500 Internal Server Error
HResult: 0x80004005
Source: Microsoft XML Extensions to SQL Server
Description: SQLXML: error loading XSL stylesheet

Here's my xls file.
BTW, I also tried to call the original namespace (http://www.w3.org/TR/WD-xsl) but it still gave me the same error message.

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  <xsl:template match = "/">
    <HTML>
    <HEAD>

    </HEAD>
    <BODY>
    <TABLE Border="1">
      <TR>
        <TH ColSpan="1">Products</TH>
      </TR>
      <TR>
        <TH>Product Name</TH>
        <TH>Price</TH>
      </TR>
      <xsl:for-each select="root/tblProducts">
        <TR>
          <TD><xsl:value-of select="@ProductName"/></TD>
          <TD><xsl:value-of select="@Price"/></TD>
        </TR>
      </xsl:for-each>
    </TABLE>
    </BODY>
    </HTML>
  </xsl:template>
</xsl:stylesheet>
 
0
as66422
Asked:
as66422
  • 5
1 Solution
 
b1xml2Commented:
as6642, did you run xmlinst.exe on the box?
0
 
b1xml2Commented:
if you did, that may have damaged SQL XML functionality.
0
 
b1xml2Commented:
either that or the pathway to the XSL Document is wrong

<?xml-stylesheet href="path.xsl" type="text/xsl"?>
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
b1xml2Commented:
References to Problems with XmlInst.exe
==========================
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q278636
0
 
as66422Author Commented:
b1xml2, thanks for your comment.
Here are my answers to your questions.
No I didn't run xmlinst.exe and I'm sure that the path to the xsl file is correct.
Any comment/suggestion will be greatly appreciated.
0
 
b1xml2Commented:
if you were to change the path to a non-existent stylesheet, see what error you will be getting. If the error is the same, then the obvious cause is the wrong path. Try absolute paths and see the results. If all else fails, I will activate the SQL XML functionality on my box and proceed from there.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now