Very Computer

just set up iis on my xp pro workstation (let's call
it 'ws1') that hosts a local test site. i also just
configured xml support in iis on ws1. the default.htm
page displays properly on the iis machine and on another
machine (say 'ws2') on the same subnet. however, the
following URL query results will display correctly on s,
under any user accout, but will not display on ws1, even
when logged in as a domain admin account:

http://<iisserver>/<virtualdirectory>/?sql=select first
name from northwind for xml auto&root=myxml

sql server runs on a server (not ws1 or ws2) on the same
subnet.

i've read that 'IE uses an XML parser known as MSXML to
display XML documents.' (ms sql server 2000 unleashed, pg
1320) - does MSXML need to be installed or configured on
every instance of IE that wants to display XML; was
something added to IE on ws1 when i configured XML
support in IIS?

i would love any help on this one... thanks!

http://ws2/<virtualdirectory>/?sql=select first name from northwind for xml
auto&root=myxml

but this one doesn't:

http://ws1/<virtualdirectory>/?sql=select first name from northwind for xml
auto&root=myxml

then check to be sure you've checked the  "allow SQL= ... or Template=...
URL queries".  Once you're satisfied both are working DISABLE the URL
queries, because you don't want some jokester to "Drop Database" on the
URL....

If they're both checked, then something else went wrong when you configured
the non-working one.  I'd delete the Virtual directory, and start over.  My
students sometimes get into this situation, and nothing I do seems to fix
it.  So I start over, and suddenly, everything's fine....

Regards,
Mike Sharp

Quote:> howdy folks.

> just set up iis on my xp pro workstation (let's call
> it 'ws1') that hosts a local test site. i also just
> configured xml support in iis on ws1. the default.htm
> page displays properly on the iis machine and on another
> machine (say 'ws2') on the same subnet. however, the
> following URL query results will display correctly on s,
> under any user accout, but will not display on ws1, even
> when logged in as a domain admin account:

> http://<iisserver>/<virtualdirectory>/?sql=select first
> name from northwind for xml auto&root=myxml

> sql server runs on a server (not ws1 or ws2) on the same
> subnet.

> i've read that 'IE uses an XML parser known as MSXML to
> display XML documents.' (ms sql server 2000 unleashed, pg
> 1320) - does MSXML need to be installed or configured on
> every instance of IE that wants to display XML; was
> something added to IE on ws1 when i configured XML
> support in IIS?

> i would love any help on this one... thanks!

i'm following the directions in "ms sql server 2000 unleashed", pg1316,
and it still only works if i'm logged in at the workstation where i
installed iis and xml support (sql server is on another server on the
same subnet).

would the results be different if we installed iis/xml on the server on
which sql server is installed?

i wanted to try it out on my workstation as we dont have a test/dev
server.

why would mighty mighty sun try to foil my first and feeble attempts at
using microsoft's xml/iis? ...i have no other explanation for why it's
not working!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

So your dev machine (or any machine that wants to do it) needs it's own copy
of IIS, with ISAPI enabled, and SQLXML. This rules out, by the way, WinXP
Home edition, though there is a hack to get it to work.  You can relocated
the sqlxml dll on the IIS box, if you need to, as long as IIS can get to it.

Yes, it can be on the SQL Box, but doesn't need to be, and in a perfect
world, probably shouldn't be...

Regards,
Mike Sharp

Quote:> thanks Mike... that suggestion worked - exactly once! when the message
> "page cannot be displayed" came up, i deleted and re-created the virtual
> directory over and over again and it hasn't worked since for any user
> account on any workstation that isn't the workstation that has iis
> installed on it (http://<localhost>/default.htm displays correctly
> everywhere on our subnet, however).

> i'm following the directions in "ms sql server 2000 unleashed", pg1316,
> and it still only works if i'm logged in at the workstation where i
> installed iis and xml support (sql server is on another server on the
> same subnet).

> would the results be different if we installed iis/xml on the server on
> which sql server is installed?

> i wanted to try it out on my workstation as we dont have a test/dev
> server.

> why would mighty mighty sun try to foil my first and feeble attempts at
> using microsoft's xml/iis? ...i have no other explanation for why it's
> not working!

> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

cheers ;)

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!