Hi!
My Windows Form application today threw the error
System.InvalidOperationException: Timeout expired.
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.
The form opens a connection to SQL Server in FORM.Load
Subsequently, while validating individual fields, a library of functions is used. Each function calls openconn() below
Public Function openconn()
libconn = New SqlConnection
libconn.ConnectionString = "Data source xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx;integrated security=false;MultipleActiveResultSets=True"
If libconn.State <> ConnectionState.Open Then
libconn.Open()
...
Go to the complete details ...