Re: Displaying XML in webbrowser
From: Irwin Dolobowsky[MS] (irwind_at_mail.microsoft.com)
Date: 04/05/04
- Next message: Tilli: "Re: Performance and Scalability of SqlXml"
- Previous message: Irwin Dolobowsky[MS]: "Re: how to filter element by attribute to be imported using SQLXML schema annotation in XML Bulk Load"
- In reply to: NSR: "Displaying XML in webbrowser"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 5 Apr 2004 10:50:06 -0700
Sorry, but does everyone have their own Sql Server that they need to access?
Why aren't they accessing the same server?
Also, be careful when using sql=. Generally we recommend not to use it in
production, just because you're opening up you server to any query the user
has permissions for. Make sure you lock the database down tight or use
somethign like annotated XSD + Xpath.
-- Irwin Dolobowsky Program Manager - SqlXml http://weblogs.asp.net/irwando This posting is provided "AS IS" with no warranties, and confers no rights. "NSR" <nick@ragannet.com> wrote in message news:1071e35e5q8174a@corp.supernews.com... > When I try to access SQL server via HTTP, I'd set up a IIS virual directory > for XML support. > then access it with > > http://localhost/myvirtualdirectory?sql="select * from sometable for xml > auto,elements &root=root > > I can do this because I set up virtual directory in IIS > > Now I'm writing a pgm to display the XML format of the SQL resultset into a > control. > The way I thought about doing this is to build the above URL internally and > send it to the Web browser > COM object and navigate to it. Problem is when my user runs my pgm on his > machine, he wont have > a virtual directory set up to handle XML via Http. Is it possible for me to > ask user to type in a > virtual directory to be used so I can pare it into my URL and internally set > up his virual directory > for him ? Since I dont even know if this is possible I am not sure if this > is even possible. What if > he doesn't even have IIS loaded on his machine ? etc > > What is the best way to do this? Any suggestions ? I'm interested to hear > what you all thnk. > Thanks > >
- Next message: Tilli: "Re: Performance and Scalability of SqlXml"
- Previous message: Irwin Dolobowsky[MS]: "Re: how to filter element by attribute to be imported using SQLXML schema annotation in XML Bulk Load"
- In reply to: NSR: "Displaying XML in webbrowser"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
