timing problem issue

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

Hi, I have some kind of timing problem, not sure how to address it yet. I
have a stored procedure that can take from 10 seconds to 2 minutes to return
data to a dataset depending on its input parameters. I have the
da.selectcommand.CommandTimeout = 0 but still when I run it for longer
processing time I get the error object not set to an instance of an object
when I try
document.close method where document is ReportDocument. The data is being
displayed in a Crystal report.
 
Thanks for the response. I added <httpRuntime executionTimeout="1000"/>
to the web config just under the complitation close tag. It builds without
errors but I am still getting the runtime error like the timeout is not
working, still using default?
The query takes 1:45 to complete so it is greater than the default timeout
for .net 2.0.
--
Paul G
Software engineer.


Eliyahu Goldin said:
What you are observing is the default timeout for http requests. For 1.1 it
is 90sec and from 2.0 it is 110sec. You can control it with

<httpRuntime executionTimeout="xxx"

in web.config file.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
Click to expand...
 
What you are observing is the default timeout for http requests. For 1.1 it
is 90sec and from 2.0 it is 110sec. You can control it with

<httpRuntimeexecutionTimeout="xxx"

in web.config file.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]http://msmvps.com/blogs/egoldinhttp://usableasp.net


Hi, I have some kind of timing problem, not sure how to address it yet. I
have a stored procedure that can take from 10 seconds to 2 minutes to
return
data to a dataset depending on its input parameters. I have the
da.selectcommand.CommandTimeout = 0 but still when I run it for longer
processing time I get the error object not set to an instance of an object
when I try
document.close method where document is ReportDocument. The data is being
displayed in a Crystal report.
Click to expand...
Click to expand...

What is the error that is being thrown from IIS? Are you trapping the
error?
 
Back
Top