Click here to Skip to main content
14,363,472 members
Rate this:
Please Sign up or sign in to vote.
Hi,

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.

Thanks
Suresh
Posted

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

Try increasing the ScriptTimeout to 600 for example.
   
Comments
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, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100