Hi,

I am facing some problem while do trasnform using XSLT. I am using sqlxml and sqlserver 2000. please help me on this... i have given the code and error message.

sqlCommandText = "<ROOT xmlns:sql='urn:schemas-microsoft-com:xml-sql'>" + Environment.NewLine +
                "<sql:query>" + strSql + "</sql:query>" + Environment.NewLine +
                "</ROOT>" + Environment.NewLine;

            SqlXmlCommand cmd = new SqlXmlCommand(conString);
            cmd.CommandType = SqlXmlCommandType.Template;
            cmd.CommandText = sqlCommandText;
            cmd.OutputEncoding = "UTF-8";
            cmd.RootTag ="root";
            XmlDocument doc = new XmlDocument();
            doc.Load(cmd.ExecuteXmlReader());
            XmlUrlResolver resolve = new XmlUrlResolver();
            XslTransform xslTran = new XslTransform();
            xslTran.Load(xslpath);
            XmlDocument xmlDocTransformed = new XmlDocument();
            XmlReader reader = xslTran.Transform(doc, null, resolve);
            xmlDocTransformed.Load(reader);


ERROR:-

The remote server returned an error: (404) Not Found.
   at System.Net.HttpWebRequest.CheckFinalStatus()
   at System.Net.HttpWebRequest.EndGetResponse(IAsyncRes ult asyncResult)
   at System.Net.HttpWebRequest.GetResponse()

error 404 means you set a request for a URL that the HTTP server couldn't locate.

There's no way we can help you diagnose this from the information supplied.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference