CODEWITHSUNDEEP
asp.netsql-serverhttpiis-7session-state
Dan An
Dan An

Reputation: 424

Response Time Out on IIS7, cannot extend to more than 30 sec (default)

I have a website which is using .net 3.5, IIS7 and SQL Server 2008.

On a webpage, click on a report download button, it loads data from SQL Server and Stream to user as an excel file.

It works fine except when the execution time and Loading time (from SQL Server) is over 30sec, then the web page time out.

I tried to change the web.config (may be wrong), but it doesn't help.

<system.web>
  <httpRuntime executionTimeout="240" maxRequestLength="20480" />
</system.web>

Can I solve this issue by configuring just IIS7? or SQL Server/Session State DB/Browser has the timeout restriction as well?

Thank

Upvotes: 1

Views: 2316

Answers (1)

Ravi Vanapalli
Ravi Vanapalli

Reputation: 9942

If you are using SQLCommand object then there is a property "CommandTimeout" which you can set and your processing should not fail.

Upvotes: 1

Related Questions