Query via HTTP insight

• Max Girth

  Grasshopper

  Points: 11

  More actions

  December 3, 2005 at 9:13 am

  #66849

  Please note, first, that I am not proficient (yet) with SQL, or with HTTP for that matter.

  I have SQL 2000 running on Windows Server 2003. This same box is also running IIS.

  If I open a browser, and enter my_server_ip_address, the default page, index.htm, opens as it should.

  This ensures me, I believe, that IIS is working properly. Right?

  I have followed the steps outlined in the "Creating the nwind virtual directory" section of SQL Server Books Online to the letter.

  According to the guide, to test the nwind virtual directory, we should enter http://my_server_ip_address/nwind?sql=SELECT * FROM Employees FOR XML AUTO&root=root

  I substitute xxx.xxx.xxx.xxx for "my_server_ip_address" but the query fails with "Paqe cannot be found".

  I can access the nwind db from within the Query Analyzer with no problem.

  My desire is pretty simple, I think.

  I just want to place a link, or links, on the default page, index.htm.

  This link should execute a very simple query against the northwind database.

  For instance, "select * from employees".

  The instructions, in my opinion, are a little vague.

  I don't know what to expect when this query works correctly, via HTTP.

  The \\inetpub\wwwroot\nwind folder is empty except for the schema and template folders, which are also empty...

  Is this correct?

  Should the nwind directory contain an index.htm???

  Does there need to be a template of some sort in the template folder?

  What about the schema folder?

  I guess what I need is a more comprehensive guide for this than SQL Server Books Online.

  Thanks in advance for any insight you may be able to provide.

• Yelena Varshal

  SSC-Dedicated

  Points: 34286

  More actions

  December 5, 2005 at 1:20 pm

  #607781

  Hi,

  had the same problem myself with the same description. I had no problems on Windows 2000 server but had on 2003 server. I had to download XMLSQL. Here are my records from my journal:

  "...Got an email from <my Co-worker> with a good link for SQLXML: 

  http://msdn.microsoft.com/msdnmag/issues/02/05/SQLXML3/default.aspx

  SQLXML 3.0

  Build Data-Driven Web Services with Updated XML Support for SQL Server 2000

  by Christian Thilmany .....I installed XMLSQL 3.0 on MyServer from

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/operations/htm/ebiz_prog_adapt_gloq.asp

  and it worked... I need to install SOAP Toolkit 2.0 in order to be able to use Web Services....."

  Hope it helps!

  Regards,Yelena Varsha