468,115 Members | 2,122 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,115 developers. It's quick & easy.

Web app leaving SQL database connections open

In an ASP.Net v2 web application that connects to a SQL 2005 database.
It appears that it is not closing the connections to the database and
leaves 100 db connections open and then the application can not open
any more connections.

Why is the database connections still active (sleeping in activity
monitor) despite the code closing the connection?

How can you enable application pooling for a web application?
Nov 20 '08 #1
2 2218

Are you using IDataReader's?

Are you CLOSING them?

"Robin9876" <ro*******@hotmail.comwrote in message
news:11**********************************@w34g2000 yqm.googlegroups.com...
In an ASP.Net v2 web application that connects to a SQL 2005 database.
It appears that it is not closing the connections to the database and
leaves 100 db connections open and then the application can not open
any more connections.

Why is the database connections still active (sleeping in activity
monitor) despite the code closing the connection?

How can you enable application pooling for a web application?

Nov 20 '08 #2
I doubt that it happens "despite the code closing the connection"
Most likely it happens because of lack of code that closes connection.
Show us the snippet of code where you work with DB.

PS: Pooling is enabled automatically, but connection needs to be closed to
become available for pooling.

George.
"Robin9876" <ro*******@hotmail.comwrote in message
news:11**********************************@w34g2000 yqm.googlegroups.com...
In an ASP.Net v2 web application that connects to a SQL 2005 database.
It appears that it is not closing the connections to the database and
leaves 100 db connections open and then the application can not open
any more connections.

Why is the database connections still active (sleeping in activity
monitor) despite the code closing the connection?

How can you enable application pooling for a web application?
Nov 20 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Mudge | last post: by
2 posts views Thread by Bryan | last post: by
3 posts views Thread by Catadmin | last post: by
1 post views Thread by Shawn H. Mesiatowsky | last post: by
3 posts views Thread by Martin B | last post: by
35 posts views Thread by Terry Jolly | last post: by
5 posts views Thread by Usman Jamil | last post: by
3 posts views Thread by didacticone | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.