Re: Connection pool close timeout

From: Kevin Yu [MSFT] (v-kevy_at_online.microsoft.com)
Date: 02/03/04 

Date: Tue, 03 Feb 2004 02:00:01 GMT

Thanks for William's quick response.

Hi Kevin,

Thank you for posting in the community!

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you need to confirm the 5 minutes'
connection lifetime in ADO.NET. If there is any misunderstanding, please
feel free to let me know.

As far as I know, the default value for the connection lifetime is '0'.
When a connection is returned to the pool, its creation time is compared
with the current time, and the connection is destroyed if that time span
(in seconds) exceeds the value specified by Connection Lifetime. This is
useful in clustered configurations to force load balancing between a
running server and a server just brought online. A value of zero (0) causes
pooled connections to have the maximum connection timeout. So please check
your connection string and see if the value of Connection Lifetime has been
set to 5 minutes.

Here is a link with more information about Connection Lifetime property in
connection string for your reference:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/
frlrfsystemdatasqlclientsqlconnectionclassconnectionstringtopic.asp

Does this answer your question? If anything is unclear, please feel free to
reply to the post.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

Relevant Pages

  • Re: VS.2005 c# Autonumber via Access with @@IDENTITY Failing
    ... this._firstName);, so that the connection can be kept open, and the ... Kevin Yu ... "This posting is provided "AS IS" with no warranties, ... Prev by Date: ...
    (microsoft.public.data.ado)
  • Re: MinPoolSize behaviour
    ... We should never have called it connection lifetime, ... notice this and bring up a couple of servers to balance the load. ... connection in the pool that is) we will check to see if it has been around ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Connection Pool Unavailable for 20 minutes ... Contd
    ... Are you talking about Connection Timeout or Connection Lifetime? ... > minute pool not available" problem every 4 hours. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Timeout in Transaction: Get two times the same data from table
    ... it´s not completely clear how to maintain my own connection lifetime. ... without any problem but on second call I get an timeout error. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Connection pool close timeout
    ... setting the ConnectionTimeout property has no affect on normal ... When the connection is dormant for 4-8 ... I understand that you need to confirm the 5 minutes'> connection lifetime in ADO.NET. ... > When a connection is returned to the pool, its creation time is compared> with the current time, and the connection is destroyed if that time span> exceeds the value specified by Connection Lifetime. ...
    (microsoft.public.dotnet.framework.adonet)