Click here to Skip to main content
14,926,277 members
Please Sign up or sign in to vote.
0.00/5 (No votes)

I am working in ASP project. While getting more data from DB using ASP , getting error HTTP 500 error. Below lines are used in ASP page

Server.ScriptTimeout = 90
Response.Buffer = False
Response.AddHeader "Content-Length", 70000000
'Option Explicit
Response.Expires = -1000
Response.ContentType = "text/xml"

Sql data are converting to xml , in IIS 6 - windows server 2003 working fine . In IIS7 windows server 2008 , User session out happening , every second asking login credentials.

Commented line Response.AddHeader "Content-Length", 70000000 , pages able to load , but while fetching huge data more than 5000 records getting error.
Please let me know what i need to change.


1 solution

Try increasing the ScriptTimeout to 600 for example.
itsureshuk 6-Jun-15 4:40am
Not working... i tried ScriptTimeOut to 600 . But same issue.
Mehdi Gholam 6-Jun-15 8:15am
Increase the timeout on your SqlCommand or SqlConnection also.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900