resetting connection to SqlServer

  • Thread starter Thread starter Tony Riv
  • Start date Start date
T

Tony Riv

Is there anyway to reset a connection to SqlServer, it seems as though the
connection remains on the workstation until it is rebooted.
 
All that's necessary is to stop the application that opened the
connection--or wait. After you close a connection, it takes between 4-8
minutes for it to timeout and close on it's own. In ADO.NET 2.0 you'll be
able to flush the connection pool (which is holding your connection open).

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
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.
__________________________________
 
Hi,

What you need to do is to call Close method of the connection, then call
Dispose method and them set connection variable to Nothing. It should clear
all the resources associated with the connection
 
Huh?
This would have no effect on the connection pool.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
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.
__________________________________
 
Thats what I found, I tried doing a close, displose and null'ing the
connection but as you say the connection pool remains active.

A good test for this is to create a table in the database. Then restore an
older version of the database and try creating the table again. The code
will fail at creating the table as it still thinks you have the table.

I may have to go to "plan B" and stop then restart the Sql Service, that
will certainly clear the connection.

I am using MSDE 2000 and wanted a simple restore procedure.

Tony R
 
Back
Top