Re: Time out Expire (asp.net)

Tech-Archive recommends: Speed Up your PC by fixing your registry

Since it is ASP.NET application, there are 3 timeouts that may involve:

Datatbase Connection timeout:

allowed time period for establishing connection to the database. It seems your app can create connection to Database, so it is not the problem.

Command timeout: allowed time for your application to wait for the command (calling a SQL statement/procedure) to finish on the database server side. For SqlCommand object, it is default to 30 (sec.). You can inccrease it longer (never set it to 0, not timeout). However, if you know the command need more time than 30sec, or even more, you may want to reconsider the application logic and change to some sort of asyc. approach. It is not good to have a web request to tie the process that long.

IIS web request timeout: by default, it is 120sec, and could be configured. You need to make sure with your website/ASP.NET settings. So, if you give your Command longer timeout (more than 120sec, again, bad design), the web request may be timed out before your Command has done its job.

All in all, let web request wait long for populate huge amount of data is not good design. So, you'd better find out true reason of timeout and rethink something, if needed.


"Hakkim sulthan" <hakkimpmk@xxxxxxxxx> wrote in message news:u0AakE8HIHA.536@xxxxxxxxxxxxxxxxxxxxxxx
iam calling a stored precedure from my program, the process is to bring
the datas in tree structure so the data is heavy , when i tried to bring
more datas its says "(Network Error (tcp_error) A communication error
occurred: " i try to increase the connection & command time out still
the same.

*** Sent via Developersdex http://www.developersdex.com ***

.

Relevant Pages

  • Re: ADO.NET timeout
    ... that connection timeout and command timeout are ... >> In addition to Val's good advice, you can also set the connection timeout ... >> Enterprise Development with VS .NET, UML, and MSF ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO.NET timeout
    ... that connection timeout and command timeout are different ... Simple specify the Connection ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Connection Timeout
    ... I set the general timeout, however, this property like the connection ... The connection timeout and the extended command timeout are two differents ... Sylvain Lafontaine, ing. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: OE6 does not connect with pop3 server
    ... Can we infer from this that you got a timeout on the EarthLink account ... My point about making an approximate timestamp is just to look at the ... E.g. as near as possible before the connection ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: Timout control with RPC/HTTP
    ... specifies the minimum connection timeout used by the ... client and RPC Proxy, in seconds. ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.exchange.admin)