Click here to Skip to main content
15,887,027 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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

VB
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

Try increasing the ScriptTimeout to 600 for example.
 
Share this answer
 
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, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900