Active Server Pages错误'ASP 0113' [英] Active Server Pages error 'ASP 0113'
问题描述
Active Server Pages错误'ASP 0113''
脚本超时
我仍然收到此错误,我不是确定我如何解决这个问题。
当我在SQL 2005上执行查询时,它只需要8秒。
此报告的存储过程已经过已经通过数据库
Engine Tuning Advisor将所有必要的索引放在相关的
表上。
当我发生时在其他新的Web服务器上运行此报告。
我已将此信息放在此报告的ASP网页上。
<%server .ScriptTimeout = 4000%>
..ConnectionTimeout = 4800
..CommandTimeout = 4800
任意想法?
谢谢。
"Active Server Pages error ''ASP 0113''
Script timed out"
I am still getting this error, and I am not sure how I could fix this.
When I execute the query at SQL 2005, it only takes 8 seconds.
The stored procedure for this report has been already went through Database
Engine Tuning Advisor to put all the necessary indexes on the associated
tables.
It happens when I run this report on other new web server.
I already put this on the ASP web page for this report.
<% server.ScriptTimeout = 4000 %>
..ConnectionTimeout = 4800
..CommandTimeout = 4800
Any idea?
Thanks.
推荐答案
" Justin Doh"写道:
"Justin Doh" wrote:
" Active Server Pages错误''ASP 0113''
脚本超时
...<%server.ScriptTimeout = 4000%> ...
.ConnectionTimeout = 4800
.CommandTimeout = 4800
有什么想法吗?
"Active Server Pages error ''ASP 0113''
Script timed out"
...<% server.ScriptTimeout = 4000 %>...
.ConnectionTimeout = 4800
.CommandTimeout = 4800
Any idea?
也许它与数据库无关。你是否处于无休止的循环中,或许缺少
a MoveNext()或其他东西?
-
戴夫安德森>
未经请求的商业电子邮件将以每封邮件
Maybe it''s not database-related. Are you in an endless loop, perhaps missing
a MoveNext() or something?
--
Dave Anderson
Unsolicited commercial email will be read at a cost of
500的费用阅读。使用
这个电子邮件地址的
表示同意这些条款。
500 per message. Use
of this email address implies consent to these terms.
Justin Doh写道:
Justin Doh wrote:
Active Server Pages错误'ASP 0113''
脚本超时
我仍然收到此错误,我不知道如何解决这个问题。
当我在SQL 2005上执行查询时,它只需要8秒。
存储过程对于这个报告已经通过
数据库引擎调优顾问将所有必要的索引放在
相关表格上。
当我在其他新的Web服务器上运行此报告时会发生这种情况。
我已将此信息放在此报告的ASP网页上。
<%server.ScriptTimeout = 4000%>
.ConnectionTimeout = 4800
.CommandTimeout = 4800
有什么想法吗?
谢谢。
"Active Server Pages error ''ASP 0113''
Script timed out"
I am still getting this error, and I am not sure how I could fix this.
When I execute the query at SQL 2005, it only takes 8 seconds.
The stored procedure for this report has been already went through
Database Engine Tuning Advisor to put all the necessary indexes on
the associated tables.
It happens when I run this report on other new web server.
I already put this on the ASP web page for this report.
<% server.ScriptTimeout = 4000 %>
.ConnectionTimeout = 4800
.CommandTimeout = 4800
Any idea?
Thanks.
在设置荒谬的超时之前,请确认您需要它们。
1.使用SQL事件探查器运行跟踪以验证存储过程
是问题
2.如果存储过程没有,请确定代码中的瓶颈
问题
>
<%
Response.Write" Code start:" &安培;现在& "< BR>"
....
Response.Write"打开连接:" &安培;现在& "< BR>"
....
Response.Write" Calling procedure:" &安培;现在& "< BR>"
....
Response.Write"处理结果:" &安培;现在& "< BR>"
....
-
Microsoft MVP - ASP / ASP.NET
请回复新闻组。我的From
标题中列出的电子邮件帐户是我的垃圾邮件陷阱,因此我不经常检查它。通过发布到新闻组,您将获得更快的回复。
Before setting ridiculous timeouts, verify that you need them.
1. use SQL Profiler to run a trace to verify that the stored procedure
is the problem
2. identify the bottleneck in your code if the stored procedure is not
the problem
<%
Response.Write "Code start: " & now & "<BR>"
....
Response.Write "Opening connection: " & now & "<BR>"
....
Response.Write "Calling procedure: " & now & "<BR>"
....
Response.Write "Processing results: " & now & "<BR>"
....
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don''t check it very often. You will get a
quicker response by posting to the newsgroup.
这篇关于Active Server Pages错误'ASP 0113'的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!