•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the RSS, Web Services and SOAP section within the Web Development category of DaniWeb, a massive community of 374,444 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,812 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our RSS, Web Services and SOAP advertiser:
Views: 4293 | Replies: 2
![]() |
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/de...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.
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/de...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.
More info:
I don't think the problem has anything to do with SP4. I used the SQL Server profiler to trace any activity in the DB. When tracing the working example on the Win2000 server I can that requests are actually made by IIS. On the Win2003 box nothing shows up, so IIS isn't even sending the SQL statement to SQL Server. Any ideas on what could be preventing the request from happening?
I don't think the problem has anything to do with SP4. I used the SQL Server profiler to trace any activity in the DB. When tracing the working example on the Win2000 server I can that requests are actually made by IIS. On the Win2003 box nothing shows up, so IIS isn't even sending the SQL statement to SQL Server. Any ideas on what could be preventing the request from happening?
•
•
Join Date: Aug 2005
Posts: 6
Reputation:
Rep Power: 0
Solved Threads: 2
Hi,
Did you find a solution to your problem?
May be the IIS version is the underlying reason for the problem. Since IIS6 is more tight when considered with IIS5. You may need to update a few configuration settings in the IIS6 panels.
Eralper
http://www.kodyaz.com
Did you find a solution to your problem?
May be the IIS version is the underlying reason for the problem. Since IIS6 is more tight when considered with IIS5. You may need to update a few configuration settings in the IIS6 panels.
Eralper
http://www.kodyaz.com
![]() |
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb RSS, Web Services and SOAP Marketplace
•
•
•
•
access ajax api asp backup blogger blogging business centro code combo daniweb data database developer development dom dropdownlist feed gdata google hacker html internet linux lonelygirl15 microsoft module msdn net news office programming reader reuse rss security server software sql standards survey video w3c weather web windows xml xoap youtube
- SQL Server 2000 Help (MS SQL)
- MS Access v/s MS SQL Server 2000 (MySQL)
- SQL SERVER 2000 Login failure in ASP.NET (ASP.NET)
- SQL Server 2000 and VB 6 (Visual Basic 4 / 5 / 6)
- Ms Sql Server 2000 (MS SQL)
Other Threads in the RSS, Web Services and SOAP Forum
- Previous Thread: Displaying XML on HTML page, Server Stats to be complete
- Next Thread: RSS feed doesn't validate but why?


Linear Mode