L
Lloyd Sheen
I am running into the connection pool running out of connections problem.
Error msg is :
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.
Do sp_who on SQL Server 2000 shows only the connection for QA and 2 other
connections. The SQL Server is on a local workstation so I can monitor what
is going on. I changed the connection string to be:
<add key="ConnectionString"
value="server=localhost;Trusted_Connection=true;database=Commerce;Min Pool
Size=5;Max Pool Size=1000" />
That does not make any change. So this means that I do about 10 connections
before the app shuts down by not allowing any other connections.
HELP
Lloyd Sheen
Error msg is :
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.
Do sp_who on SQL Server 2000 shows only the connection for QA and 2 other
connections. The SQL Server is on a local workstation so I can monitor what
is going on. I changed the connection string to be:
<add key="ConnectionString"
value="server=localhost;Trusted_Connection=true;database=Commerce;Min Pool
Size=5;Max Pool Size=1000" />
That does not make any change. So this means that I do about 10 connections
before the app shuts down by not allowing any other connections.
HELP
Lloyd Sheen