MS SQL XML - sql 2000 with a frontal IIS 6.0 template XML

Author

sql 2000 with a frontal IIS 6.0 template XML

vincent

2005-09-01, 11:23 am

Hello,

I would like to use http to send query to my sql server

I've got a frontal server IIS 6.0 (server 2003 named frontal1)

I've got a sql 2000 on a server 2003 named sqlvirtual1

I've configurated the virtual directory IIS (nwind) with the sql tool
(iis virtual directory management for sql server)

After the setup, I've checked that the virtual directory had the correct
component
3 directories
schema
dbobject
template (with a file template.xml)

In the properties tab of the virtual directory nwind
I've checked that the sqlisapi.dll is list in the configuration

when I test http://frontal1/nwind/template/template.xml
the message appear
"the page is unfoundable"
(the sentence is probably a bad translation of a french message " la page
est introuvable)

I 've got another question :
Where can I see the relation between the database name and the virtual
directory?

Thank in advance for all your information

Vincent

Bertan ARI [MSFT]

2005-09-08, 3:23 am

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.

"vincent" <vincent@discussions.microsoft.com> wrote in message
news:DC3DC14B-A601-4632-AC46- F7A6CA222F87@microso
ft.com...
> Hello,
>
> I would like to use http to send query to my sql server
>
> I've got a frontal server IIS 6.0 (server 2003 named frontal1)
>
> I've got a sql 2000 on a server 2003 named sqlvirtual1
>
> I've configurated the virtual directory IIS (nwind) with the sql tool
> (iis virtual directory management for sql server)
>
> After the setup, I've checked that the virtual directory had the correct
> component
> 3 directories
> schema
> dbobject
> template (with a file template.xml)
>
> In the properties tab of the virtual directory nwind
> I've checked that the sqlisapi.dll is list in the configuration
>
> when I test http://frontal1/nwind/template/template.xml
> the message appear
> "the page is unfoundable"
> (the sentence is probably a bad translation of a french message " la page
> est introuvable)
>
> I 've got another question :
> Where can I see the relation between the database name and the virtual
> directory?
>
> Thank in advance for all your information
>
> Vincent
>
>

Sponsored Links