Getting error Reach maximum pool size reached in asp.net 2.0

  • Thread starter Thread starter Ripon1
  • Start date Start date
R

Ripon1

Guest
I have an web application developed using asp.net 2.0. It uses enterprise library to communicate with the database. Every once in a while I get the maximum pool size error. Although I set the pool size to 200, I still get this error. How could I solve this issue? Here is the code that use to create the database and connection string? Do I need to close the database so that it frees up the connection.

Public NotInheritable Class ConnectionStrings

Private Sub New()

End Sub


Public Shared ReadOnly SQL As System.Configuration.ConnectionStringSettings = System.Configuration.ConfigurationManager.ConnectionStrings("SQLDB")

End Class


Public Shared ReadOnly Property SQLDB() As Database

Get

Static db As Database = DynamicDatabaseFactory.CreateDatabase(ConnectionStrings.SQL.ConnectionString, DBProviderType.SqlServer)

Return db

End Get

End Property

I would appreciate if you could help me showing how to avoid the max pool size error.

Thanks,





Ripon

Continue reading...
 
Back
Top