How to close Connections

G

Guest

There's an application
which runs on .NET Framework 1.1 and uses SqlClient class to connect to
database.
It is a server application, but sometime the application is closed without
letting int finish it's job.
I've seen that when this happens there could be open connections to the
database.-
Is there a way, in which I can check if there are unused connections and
destroy them the next time I open the application?.
 
W

William \(Bill\) Vaughn

When an application is closed the connections it "owns" are closed and
disposed automatically.
In IIS, your application is hosted by a proxy that holds ownership. When
your "application domain" ends, the connections it owns are closed and
destroyed.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to handle connections on heavely used app 5
Problem with Data Readers and connections 1
Connections in pool not being reused 7
Suddenly slow ado.net connections 5
Connection timeout 1
Enlisting in distributed transaction raises COM error 2
How can I monitor open database connections? 1
Oracle Database Connection Pool - Too many connections being used 2

Top