ASP中的HTTP 500错误,从sql DB获取更多5000条记录 [英] HTTP 500 Error in ASP , while fetching more 5000 records from sql DB
问题描述
我在ASP项目中工作。使用ASP从DB获取更多数据时,会收到错误HTTP 500错误。以下行用于ASP页面
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数据正在转换到xml,在IIS 6中 - windows server 2003正常工作。在IIS7 Windows Server 2008中,用户会话发生,每秒都要求登录凭据。
注释行Response.AddHeaderContent-Length,70000000,页面能够加载,但是在获取超过5000条记录的大量数据时会出现错误。
请告诉我需要更改的内容。
谢谢
Suresh
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
推荐答案
尝试将 ScriptTimeout
增加到600例如。
Try increasing the ScriptTimeout
to 600 for example.
这篇关于ASP中的HTTP 500错误,从sql DB获取更多5000条记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!