I want to return an XML stream from a SQL 2000 database using a URL query.
I have been trying to get a simple M$ Northwind example to work on a Windows 2003 server but I can't get it to work. I can get the simple example to work on a Win2000 server though.
I set up the required virtual directory following the steps located here (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsql/ac_xml1_2xvd.asp). I then try to run a simple query. (http://<IISServer>/<Virtual Directory Name>?sql=Select FirstName From Employees FOR XML AUTO&root=root)
The example works perfectly on the 2000 box but not on the 2003. The only difference between the two machines is that SQL Server on the 2003 machine has service pack 4 but the 2000 machine only has sp3. I can't find any articles that list problems with sp4 and I don't want to install sp4 on my 2000 box now, just in case I break something. Especially since I can't remove it once it is installed.
Has anyone run into a problem like this before or does anyone have any suggestions? I am really stuck. Thanks.