Problem with connection pooling
-
Dear all, I have a problem with connection pooling. I programmed in VB.NET with ADO.NET and SQL Server. Here is my code in one form: Dim conn as new SqlConnection(strConnectionString) conn.Open .... conn.Close There are 3 SqlConnection instance in my code. But If I run the form several times (about 25 times), it occurred an error: 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 I am sure that I have closed conn as soon as posible, so I do not know why that error happend. Any comment are welcome. Thanks for reading.
-
Dear all, I have a problem with connection pooling. I programmed in VB.NET with ADO.NET and SQL Server. Here is my code in one form: Dim conn as new SqlConnection(strConnectionString) conn.Open .... conn.Close There are 3 SqlConnection instance in my code. But If I run the form several times (about 25 times), it occurred an error: 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 I am sure that I have closed conn as soon as posible, so I do not know why that error happend. Any comment are welcome. Thanks for reading.
It will only be caused if you have some connection left open Akif
-
It will only be caused if you have some connection left open Akif