olisemalis
MIS
Hello,
I´m getting some random errors while accessing SQL server in my application (VB.net):
1)
ExecuteScalar requires an open and available Connection. The connection's current state is closed.
2)
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 have the default pool which I think is 100.
When running this query against the database, I´m getting between 480-500 rows (which I believe are connections in the pool). If the pool is the default, I don´t know how can I get 500?
SELECT spid, uid=rtrim(loginame), Program_name=rtrim(Program_name),
dbname=db_name(dbid), status=rtrim(status) FROM master.dbo.sysprocesses
WHERE loginame = 'my_app'
I already sow if I was closing all the connections, and I think I am.
Any ideas on this?
Thank you
I´m getting some random errors while accessing SQL server in my application (VB.net):
1)
ExecuteScalar requires an open and available Connection. The connection's current state is closed.
2)
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 have the default pool which I think is 100.
When running this query against the database, I´m getting between 480-500 rows (which I believe are connections in the pool). If the pool is the default, I don´t know how can I get 500?
SELECT spid, uid=rtrim(loginame), Program_name=rtrim(Program_name),
dbname=db_name(dbid), status=rtrim(status) FROM master.dbo.sysprocesses
WHERE loginame = 'my_app'
I already sow if I was closing all the connections, and I think I am.
Any ideas on this?
Thank you