Re: Set up timeout

On Nov 3, 2:45*pm, "aspfun via DotNetMonster.com" <u53138@uwe> wrote:
> I am going to make a setting for timeout in the following places:
> 1) SQLCommand.CommandTimeout
> 2) IIS, default web site, properties, connection timeout
> 3) webcofig, ConnectionString, timeout
> Questions:
> Do I need to setup all three place or only one or two?
> (Provide that code is good and connection was closed after update or insert
> procedure)
>
> --
> Message posted viahttp://www.dotnetmonster.com

It depends on what you need to do. Connection Timeout in IIS sets the
time before the server disconnects an inactive user.
SQLCommand.CommandTimeout determines the maximum number of seconds the
command is given to execute the sql. And the timeout of connection
string in the web.config file will only controls the timeout of the
connection to the database. All three options do different things.

Alexey Smirnov