Re: Disconnect from sql server database
From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 01/31/05
- Next message: MSFT: "RE: Problem getting external data using Access"
- Previous message: William Wang[MSFT]: "RE: Linked server 7302 error"
- In reply to: Eyal: "Disconnect from sql server database"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 31 Jan 2005 11:37:37 +0100
My guess is that you are using connection pooling. This is the default
setting for SqlClient. Do please check about connection pooling in .Net
documentation if this is your problem.
-- Dejan Sarka, SQL Server MVP Associate Mentor www.SolidQualityLearning.com "Eyal" <eg@margan.com> wrote in message news:eAAkq$2BFHA.3236@TK2MSFTNGP15.phx.gbl... > Hi > > > > I have c# application that uses SQL SERVER databases. > > The problem is that after I close all connections to a database in order to > make actions (detach, copy or delete) on the current database I get a > message saying that the database still has connections. > > > > At the Enterprise manager I can see that the current database still has 2 > connections although I closed them in my application. > > > > I would like to disconnect from the database through the application and > make the actions that were mentioned above, how can I do that? > > > > Thanks, > > Eyal > >
- Next message: MSFT: "RE: Problem getting external data using Access"
- Previous message: William Wang[MSFT]: "RE: Linked server 7302 error"
- In reply to: Eyal: "Disconnect from sql server database"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
