IIS Virtual Directory setup not working

[vbajock]

I am trying to set up web access to a SQL Server 2000 database using the IIS Virtual Directory Management tool. So far, no luck. It looks like it should be pretty straight foward. I created the Virtual Directory in IIS Virtual Management Server using Integrated Authentication to match my SQL Server, set the data source stuff, set the virtual and physical directory, set it to Allow URL Queries in settings. The book I am using as a tutorial says to use

http://iisserver/Northwind?sql=SELECT+TOP+1+ContacName+From+Customers

to test it. I get a server not found page. Is the Iisserver in the string above supposed to be my actual website name? I tried several permutations of it and it didn't work. Is there anything that has to be running on the SQL server? Any help appreciated!

 

[clarkin]

Yes, its the name of your IIS server: on your own machine it could be

http://localhost/Northwind?sql=SELECT+TOP+1+ContacName+From+Customers

Create a bog standard ASPtest.asp file with

<%
response.write &quot;asp works&quot;
%>

in it and check

http://localhost/ASPtest.asp

until you get the right IIS name.



Posting code? Wrap it with code tags: [ignore]

[/ignore][code]CodeHere

[ignore][/code][/ignore].