October 2, 2006 at 10:50 pm
The online books for SQL Server 2005 are aplenty of examples regarding retrieving data for the database in the form of web services involving SOAP messaging.
However, I cannot find anything explaining how to retrieve data from a web browser in the form: http://servername/sql=sqlquery (eg: http://localhost/sql=select%20*%20from%20customersfor%20xml%20auto) (select * from customers for xml auto)
At least to my knowledge this was the way things were done in SQL Server 2000 through a IIS virtual directory.
Why this way and not a web service ?
Because this way I can place a sql command line on the documentsource property of the «asp:xml» control and ... voilá ! -it keeps things simple. With a couple-of-lines asp.net page and an xsl file I can have very fast results.
How such a straight-through query can be invoked from SQL Server 2005 ? I mean, if I have to build a web service for such a query it means I have to build a WSDL class and thus adds another piece of code to maintain (think of parameter definitions etc). The other way I just only need to modify the database and the sql command invoking the database, no need to modify intermediate classes and the like.
Please advice.
Thanks.
October 5, 2006 at 8:00 am
This was removed by the editor as SPAM
July 7, 2007 at 2:36 am
I have the same question and I cannot find anything. I search almost a week. I believe SQL server 2005 have make things much more complex. The simplicity has gone since the .net invention. I'm thinking to migrate to mySQL
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply