Hi Chris. Blank page is not an error. Problem is response.write. If the xml 
has values only on attributes, there is nothing to show when you do 
response.write. First try to render the xml as xml instead of text. e.g.,

response.contentType="text/xml"
xmldoc.save response

If problem still persists, let us know that. If it renders properly, now we 
can discuss the xslt issue.

-- 
Pohwan Han. Seoul. Have a nice day.
"Joe Fawcett" <joefawcett@h...> wrote in message 
news:uLURPCDIFHA.2984@T......
> "Chris Kennedy" <ck001s7253nospam@b...> wrote in message 
> news:OX1t2zCIFHA.3444@T......
>>I have an SQL Server outputting some XML - when I put the XML in a text 
>>file
>> and load it via the C drive it loads. When I try it over http the page
>> doesn't display any data. I have playing around with streams but I can't 
>> get
>> it to work. Can anyone point me in the right direction
>>
>>
>> set xmlDoc = CreateObject("microsoft.xmldom")
>> set xslDoc = CreateObject("microsoft.xmldom")
>> set strXML = CreateObject("adodb.stream")
>>
>> xmlDoc.async = false
>> xslDoc.async = false
>>
>> strXML.open
>> strXML.WriteText "http://localhost/nav/template/sqltemp.xml", adWriteChar
>>
>> xmldoc.load(server.mappath("nav.xml")) - this works
>> xmldoc.load(strXML.ReadText) - this doesn't
>> xsldoc.load(server.mappath("xsl.xsl"))
>>
>> strout =  xmlDoc.transformNode(xsldoc)
>>
>>
> You don't need to use a stream if the url returns xml, just use 
> domdocument.load(url) or xmlhttp class.
>
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsdk/html/dom_reference.asp?frame=true
>
>
> -- 
>
> Joe (MVP)
>