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
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
>