Connection Pooling Error

I am using the following Connction string in web.config in asp.net
application
<add key="ConnectionInfo" value="Data Source=MyServer; Min Pool Size=5;Max
Pool Size=100; Connect Timeout=120; Initial Catalog=TestDB;User
ID=sa;Password=******;"/>

Application is running fine but after couple of days I got the follwong
exception on login page but there is no error and all connection are closed
properly. Then I reset IIS server & site come up again after IIS reset

The Exception is

The timeout period elapsed prior to obtaining a connection from the pool.
This may have occurred because all pooled connections were in use and max
pool size was reached.
at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(D bConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(D bConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()

Plese could you help me
the server is the website is live and client is trouble

Thanks
SA
shahzad [ Fr, 04 April 2008 12:53 ] [ ID #1935390 ]

Re: Connection Pooling Error

Close database connections.... Always..... No matter what happened....




George.


"shahzad" <sapk81 [at] yahoo.com> wrote in message
news:eV%23jkIklIHA.536 [at] TK2MSFTNGP06.phx.gbl...
>I am using the following Connction string in web.config in asp.net
>application
> <add key="ConnectionInfo" value="Data Source=MyServer; Min Pool Size=5;Max
> Pool Size=100; Connect Timeout=120; Initial Catalog=TestDB;User
> ID=sa;Password=******;"/>
>
> Application is running fine but after couple of days I got the follwong
> exception on login page but there is no error and all connection are
> closed properly. Then I reset IIS server & site come up again after IIS
> reset
>
> The Exception is
>
> The timeout period elapsed prior to obtaining a connection from the pool.
> This may have occurred because all pooled connections were in use and max
> pool size was reached.
> at
> System.Data.ProviderBase.DbConnectionFactory.GetConnection(D bConnection
> owningConnection)
> at
> System.Data.ProviderBase.DbConnectionClosed.OpenConnection(D bConnection
> outerConnection, DbConnectionFactory connectionFactory)
> at System.Data.SqlClient.SqlConnection.Open()
>
> Plese could you help me
> the server is the website is live and client is trouble
>
> Thanks
> SA
>
George Ter-Saakov [ Fr, 04 April 2008 14:58 ] [ ID #1935396 ]
Microsoft » microsoft.public.dotnet.framework.aspnet » Connection Pooling Error

Vorheriges Thema: Extract data from Pdf files
Nächstes Thema: RE: Forcing browser to reload the "same page" with "mapped URL"