PC Review


Reply
Thread Tools Rate Thread

How to close Connections

 
 
=?Utf-8?B?RWR1YXJkbyBGb25zZWNhIEIu?=
Guest
Posts: n/a
 
      22nd Nov 2005
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?.
 
Reply With Quote
 
 
 
 
William \(Bill\) Vaughn
Guest
Posts: n/a
 
      22nd Nov 2005
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.
__________________________________

"Eduardo Fonseca B." <(E-Mail Removed)> wrote in
message news:A1DFDDF0-99E5-48FF-9195-(E-Mail Removed)...
> 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?.



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Netstat then close connections? =?Utf-8?B?ZW5ubWE=?= Windows XP Networking 0 3rd Dec 2006 05:08 AM
How to close all connections of a database ad Microsoft ADO .NET 1 15th May 2006 11:43 PM
close db connections Howard Microsoft ASP .NET 3 10th Apr 2006 11:12 PM
How WinXp close all connections at log off? Lauro Windows Networking 0 16th Nov 2005 01:20 PM
SocketException/How To Close Connections? OvErboRed Microsoft C# .NET 0 23rd Jul 2003 06:17 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:28 PM.