MS SQL XML - Accessing SQL via http

Author

Accessing SQL via http

Lost and Confused

2005-09-07, 9:23 am

Hello,
Apologies if this is in the wrong newsgroup...

I have followed the tutorial in Books Online that is called "Creating the
nwind Virtual Directory". Everything looks ok but I get an error that
says: -
"HTTP Error 404 - File or directory not found. Internet Information Services
(IIS) when I try to test it using http://<IISServer>/nwind?sql=SELECT * FROM
Employees FOR XML AUTO&root=root

I have looked all over trying to find out what I have done wrong :(
Is there anything else that needs to be set up?

Thanks in advance
Brian.

Bertan ARI [MSFT]

2005-09-07, 8:24 pm

Could you please disable "Show friendly HTTP error messages" option in
Advanced tab of IE Options? This should give you more precise error
messages.

In the mean time, please ensure that you enable sql queries on the virtual
directory settings.

--
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.

"Lost and Confused" < lostandconfused@nowh
ere.com> wrote in message
news:431ef381$0$2119
0$db0fefd9@news.zen.co.uk...
> Hello,
> Apologies if this is in the wrong newsgroup...
>
> I have followed the tutorial in Books Online that is called "Creating the
> nwind Virtual Directory". Everything looks ok but I get an error that
> says: -
> "HTTP Error 404 - File or directory not found. Internet Information
> Services (IIS) when I try to test it using
> http://<IISServer>/nwind?sql=SELECT * FROM Employees FOR XML
> AUTO&root=root
>
> I have looked all over trying to find out what I have done wrong :(
> Is there anything else that needs to be set up?
>
> Thanks in advance
> Brian.
>

Lost and Confused

2005-09-07, 8:24 pm

Hi,
Thanks for replying, I was beginning to despair ;)

I have disabled the friendly errors as you suggested but the 404 page still
doesn't show any more detail than before.
The sql queries were already enabled on the 'nwind
Properties/Settings/Options' tab

Do you have any other suggestions?

Thanks
Brian.

"Bertan ARI [MSFT]" <bertan@online.microsoft.com> wrote in message
news:eTzZVB$sFHA.3604@tk2msftngp13.phx.gbl...
> Could you please disable "Show friendly HTTP error messages" option in
> Advanced tab of IE Options? This should give you more precise error
> messages.
>
> In the mean time, please ensure that you enable sql queries on the virtual
> directory settings.
>
> --
> Bertan ARI
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>
>
> "Lost and Confused" < lostandconfused@nowh
ere.com> wrote in message
> news:431ef381$0$2119
0$db0fefd9@news.zen.co.uk...
>
>

Bertan ARI [MSFT]

2005-09-08, 3:23 am

I am sorry but that's all I could say. It is strange that you cannot see
more detailed error message instead of 404.

Can you access the web server for different directories and pages?

--
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.

"Lost and Confused" < lostandconfused@nowh
ere.com> wrote in message
news:431f5d05$0$1795
0$db0fefd9@news.zen.co.uk...
> Hi,
> Thanks for replying, I was beginning to despair ;)
>
> I have disabled the friendly errors as you suggested but the 404 page
> still doesn't show any more detail than before.
> The sql queries were already enabled on the 'nwind
> Properties/Settings/Options' tab
>
> Do you have any other suggestions?
>
> Thanks
> Brian.
>
>
> "Bertan ARI [MSFT]" <bertan@online.microsoft.com> wrote in message
> news:eTzZVB$sFHA.3604@tk2msftngp13.phx.gbl...
>
>

Bertan ARI [MSFT]

2005-09-08, 7:23 am

I just remember.

If you are using IIS6, you should enable some options on iis configuration
for security reasons:
http://support.microsoft.com/defaul...4&Product=sql2k

If this doesn't work, follow the steps given in this article:
http://sqlxml.org/faqs.aspx?79

--
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.

"Lost and Confused" < lostandconfused@nowh
ere.com> wrote in message
news:431f5d05$0$1795
0$db0fefd9@news.zen.co.uk...
> Hi,
> Thanks for replying, I was beginning to despair ;)
>
> I have disabled the friendly errors as you suggested but the 404 page
> still doesn't show any more detail than before.
> The sql queries were already enabled on the 'nwind
> Properties/Settings/Options' tab
>
> Do you have any other suggestions?
>
> Thanks
> Brian.
>
>
> "Bertan ARI [MSFT]" <bertan@online.microsoft.com> wrote in message
> news:eTzZVB$sFHA.3604@tk2msftngp13.phx.gbl...
>
>

Lost and Confused

2005-09-08, 7:24 am

Fantastic :)
I followed the first link and added the SQLXML web service extension, which
cured the problem.
I have now unchecked the 'Allow URL queries'

Thanks for your help
Brian.

"Bertan ARI [MSFT]" <bertan@online.microsoft.com> wrote in message
news:uQxZ5AFtFHA.2792@tk2msftngp13.phx.gbl...
>I just remember.
>
> If you are using IIS6, you should enable some options on iis configuration
> for security reasons:
> http://support.microsoft.com/defaul...4&Product=sql2k
>
> If this doesn't work, follow the steps given in this article:
> http://sqlxml.org/faqs.aspx?79
>
> --
> Bertan ARI
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>
>
> "Lost and Confused" < lostandconfused@nowh
ere.com> wrote in message
> news:431f5d05$0$1795
0$db0fefd9@news.zen.co.uk...
>
>

Sponsored Links