all groups > sql server connect > january 2005 >
You're in the

sql server connect

group:

Disconnect from sql server database


Disconnect from sql server database Eyal
1/31/2005 10:37:25 AM
sql server connect:
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

Re: Disconnect from sql server database Dejan Sarka
1/31/2005 11:37:37 AM
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

[quoted text, click to view]

AddThis Social Bookmark Button