Sql server and Asp.net closing connection does not close the Sql Server Session

Question

I'm using an Asp.NET Web Application with MSSQL Server. In my page i open a connection and i close it at the end of page. But in Sql Analyzer the Sql session is still there, giving me after some amount of time a connection pool limits exceed error. Sessions are cleared only when i shutdown the webserver.

Can someone explain how to fix this? Thanks

This is the code i'm using:

Conn = new SqlConnection(StrConn);
Conn.Open();

.....

Conn.Close(); // In the debugger i can see connection state = closed
Conn = null;

Can you post the code that's opening and closing the connection. — RubbleFord
– RubbleFord, Commented Jul 2, 2012 at 10:58
Most likely connection pooling issue - try adding Pooling=false to the connection string. What happens? — user447356
– user447356, Commented Jul 2, 2012 at 11:51
Might need some more detail than that... Where is the connection opened, where is it closed? How is the open called? — Paddy
– Paddy, Commented Jul 2, 2012 at 11:51
@ShadowThePrincessWizard you are legend. Thanks a lot man, I just added that magic parameter in the connection string and now it works as it should. — ShadyOverflow
– ShadyOverflow, Commented Dec 2, 2019 at 9:38
@ShadyOverflow huh, lol.... so much time passed. Will post this as answer. Thanks for the reminder! (I know you're not the OP. ;)) — user447356
– user447356, Commented Dec 2, 2019 at 9:46

user447356 · Accepted Answer · 2019-12-02 09:48:15Z

2

This appears to be a connection pooling issue.

Add Pooling=false to the connection string, and the database won't keep the connection open.

answered Dec 2, 2019 at 9:48

user447356

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sql server and Asp.net closing connection does not close the Sql Server Session

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related