I've got some ASP written that works perfect when pull a couple thousand record, but when I pull more, I get the dreaded:

HTTP 500 - Internal server error

Can someone tell me how to get around this??

I've tried adding the following and it doesn't seem to make a difference.

cn.CommandTimeout = 300
Server.ScriptTimeout = 1800
Session.Timeout = 300
cn.ConnectionTimeout = 1800

Changing the length of time doesn't make a difference either and it errors long before 300 seconds are up, when pulling to many records at once.

After some playing around with the code, since the http 500 error is so generic, I found the real problem was buffer size. I then added <%Response.Buffer = False%>.

Now I have another problem. I'm now getting an Out of Memory Error.

Can anyone help??

Thanks.

How much data are you pulling exactly?

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor :.
Wrox Books 24 x 7
================================================== =========

How much depends on what the search criterias are selected. Regardless, I've got it working.

All I had to do was set the response.buffer to true and do a response.flush()

So far, I've been able to grab of 50MB's of data and it hasn't bombed!

Yipee!!!