Hello,
I have the enviable task of migrating our sql 2000 server infrastructure to sql 2005. One of a couple of thousand bits of research I have to do is "What happens with the IIS SQL virtual directory, especially pertaining to XML, in SQL 2005?"
We have set up some simple AJAX components that retrieve XML web related services via IIS (these are only local services).
e.g. onclick =
(replace space with +'s)
XML is read in and parsed via AJAX and displayed.
Is there an sql 2005 equivalent to this "sql=" parameter?
I have examined the http implementation in sql 2005, the Create Endpoint query, setting up of web methods as per stored procedures and the really cool xmlschema
but nothing i have read corresponds with our current processing.
Apparently (what i can make out) a .NET web service is needed to invoke the methods created in CREATE ENDPOINT. From Peter Stromberg's (Phd, MVP OBE) tutorial on the matter , he describes (or hints, he didn't really want to go into detail)that an array object is returned via web services endpoint object.
Is there a way of passing sql statements by URL and not have to employ a .NET web service in sql 2005? If i have to code some web services then I guess I have to.
Many thanks,
tek-tips is fantastic
Anthony Lawrence
I have the enviable task of migrating our sql 2000 server infrastructure to sql 2005. One of a couple of thousand bits of research I have to do is "What happens with the IIS SQL virtual directory, especially pertaining to XML, in SQL 2005?"
We have set up some simple AJAX components that retrieve XML web related services via IIS (these are only local services).
e.g. onclick =
(replace space with +'s)
XML is read in and parsed via AJAX and displayed.
Is there an sql 2005 equivalent to this "sql=" parameter?
I have examined the http implementation in sql 2005, the Create Endpoint query, setting up of web methods as per stored procedures and the really cool xmlschema
but nothing i have read corresponds with our current processing.
Apparently (what i can make out) a .NET web service is needed to invoke the methods created in CREATE ENDPOINT. From Peter Stromberg's (Phd, MVP OBE) tutorial on the matter , he describes (or hints, he didn't really want to go into detail)that an array object is returned via web services endpoint object.
Is there a way of passing sql statements by URL and not have to employ a .NET web service in sql 2005? If i have to code some web services then I guess I have to.
Many thanks,
tek-tips is fantastic
Anthony Lawrence
