Connection pooling Problem - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Connection pooling Problem

Author

Topic

aoriju
Posting Yak Master

156 Posts

Posted - 2009-11-18 : 04:58:35

I got a problem like 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(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at SqlHelper.ExecuteReader(String spName, Object[] parameterValues)
at MasterPage.IsValidSession()
at MasterPage.Page_Load(Object sender, EventArgs e)

how to solve these issues permentaly

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2009-11-18 : 08:28:30

this is more of a .net C# problem rather than SQL, next time post it in the .net forum.

I would advice you to .

1. Properly close your connection, which i cant seem to see done above
2. increase the connection timeout property

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources