Tuesday, March 20, 2012

Cant access Northwind database

I'm using XP Pro and I have the Developer's version of SQL Server installed. I downloaded SQLXML 3.0 and created a virtual directory named nwind.

I then entered the following on my IE browser:

http://<IIServer>/nwind?sql=SELECT FirstName, LastName FROM Employees FOR XML AUTO&root=root

the result is:
"The page cannot be displayed..."

I'd appreciate any help.

Thanks,
Pathttp://<IIServer>/nwind?sql=SELECT FirstName, LastName FROM Employees FOR XML AUTO&root=root

Is that a typo, or are you trying to pass a variable to a directory? when you say /nwind?sql='foo' then you should get page cannot be displayed, right? Don't you have to say /nwind/default.asp?sql='foo' ??

or will the virtual directory/IIS understand what you mean?sql

No comments:

Post a Comment