Close the Active connection of the DB before running web application
Posted on 2007-07-29
I have a database created in MS SQL 2005, and I am using an asp.net 2.0 and C# to develop a system. When I open the database in Visual Studio Database Explorer or Microsoft SQL Management Studio and I forget closing the connection before running my web application, when the web application tries to read from the DB it cannot login to the DB. I know it is because that the DB is open somewhere. How can I close any open connection(i don't mean datareaders or dataadapters connection, i mean the connection which was opened for example using sql management studio to be explored) of the DB? I want something generic as well because the application has been designed to support different DBMSs.