Out of Memory Exception

I have a web service developed using vb.net 1.1. The web
service returns xml from selected data from SQL Server
using XML AUTO.

The web service runs properly on smaller databases on both
IIS 5 (Windows 2000 Server) and IIS 6 (Windows 2003
Server), but returns an out of memory exception when run
against larger databases on IIS 5. I am trying to figure
out the difference between IIS 5 and IIS 6 which is
causing this, and a solution.

tdevere
Mon Feb 02 00:36:41 CST 2004

Hi Erik,

Help me out... where is the out of memory exception coming from?

I am not sure that the problem is IIS, since the problem happens when you
change databases...

What type of data source are you posting to?

Has this ever worked in the past?

Also, you may be posting in the incorrect newsgroup - depending on where
you're getting the error message from... let's start with this
information...


Thank you,

Tony DeVere [MSFT]
Microsoft IIS
Newsgroup Support
tdevere@online.microsoft.com

"Please do not send email directly to this alias. This is our online
account name for newsgroup participation only."

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

anonymous
Mon Feb 02 11:58:07 CST 2004

Hi Tony,

The database is SQL 2000. The web service works properly=20
for smaller databases on IIS 5, and for any size database=20
on IIS 6.

Thanks,
Erik

>-----Original Message-----
>Hi Erik,
>
>Help me out... where is the out of memory exception=20
coming from?
>
>I am not sure that the problem is IIS, since the problem=20
happens when you=20
>change databases...
>
>What type of data source are you posting to?
>
>Has this ever worked in the past?
>
>Also, you may be posting in the incorrect newsgroup -=20
depending on where=20
>you're getting the error message from... let's start with=20
this=20
>information...
>
>
>Thank you,
>
>Tony DeVere [MSFT]
>Microsoft IIS
>Newsgroup Support
>tdevere@online.microsoft.com
>
>"Please do not send email directly to this alias. This is=20
our online=20
>account name for newsgroup participation only."
>
>This posting is provided "AS IS" with no warranties, and=20
confers no rights.=20
>You assume all risk for your use. =A9 2001 Microsoft=20
Corporation. All rights=20
>reserved.
>
>.
>

tdevere
Tue Feb 03 04:03:33 CST 2004

I should have asked if you were using ADO as well...

Try posting your problem to one of our data access newsgroups... this isn't
an IIS issue from what I can tell.

http://communities2.microsoft.com/communities/newsgroups/en-us/default.aspx?
dg=microsoft.public.dotnet.framework.adonet&cat=en-us-netdevelopment&lang=en
&cr=US



Thank you,

Tony DeVere [MSFT]
Microsoft IIS
Newsgroup Support
tdevere@online.microsoft.com

"Please do not send email directly to this alias. This is our online
account name for newsgroup participation only."

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.