Sometimes ASP Page Fails

[carlosalbertoxp]

I have an ASP page that works well when i display less than 2,000 records aprox. But when I diplay more than 2000 records i get an "CANNOT FIND
SERVER OR DNS ERROR". The errors appears instantly when i load the page.

Is there a limit in IIS or ASP pages for displaying data?


Any idea???

Thanks

[neocool00]

You need to turn off "Show friendly errors". That way you can see the true error that is occuring.

Tools-->Internet Options
Advanced Tab
Uncheck the box next to "Show friendly HTTP error messages."

A wild guess here would be that your script is taking too long to execute and it's timing. In which case to increase the amount of minutes before timeout, just use Sever.ScriptTimeout = value of time in seconds (60 would be a minute). If I am running into timeout issues, I typically will bump it up to 600 (equals 10 minutes) and then just go from there.

[Bullschmidt]

And/or for increased page execution speed perhaps index database fields used in criteria or sorting...