For XML Problem with IIS6 and W2k3

Hi All,
I am having the EXACT same problem that all of you have so eloquently
described. Was there any luck with either the patches or the use of
SQLXMLOLEDB instead of SQLOLEDB?
Thanks much.
Keith
"ajsmith02" wrote:
> To specify the problem. This chunk of code has been working for about 3
> years on IIS5 and W2K. The sql that gets executed is passed in as a strin
g
> variable. To answer your question the for xml queries always runs correct
ly
> in sql server. In the IIS6 and W2k3 combo this code runs fine for days an
d
> then all of a sudden it bombs without an error message. I have isolated t
he
> place in the asp code snippet below on this line:
> adoCmd.Execute , , adExecuteStream
> My next step is to recycle the application pool and for the most part that
> gets things going again. Sometimes I have to restart IIS and still someti
mes
> I have to reboot the server all together. If something where wrong with t
he
> code then it should never work. If something were wrong with the sql bein
g
> executed then I should get a sql server error.
> Thanks for the reply.
> "Michael Rys [MSFT]" wrote:
>Can you post a repro of this scenario or the one that you have. I can ask
the stress team here to run and analyse this one.
Thanks
Chandra
--
---
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"klockwood" <klockwood@.discussions.microsoft.com> wrote in message
news:0503B98B-2672-400A-A4D4-DE62CB216C18@.microsoft.com...
> Hi All,
> I am having the EXACT same problem that all of you have so eloquently
> described. Was there any luck with either the patches or the use of
> SQLXMLOLEDB instead of SQLOLEDB?
> Thanks much.
> Keith
> "ajsmith02" wrote:
>