I am populating an object from MS SQL2000 server. The SQL server has a linked server which provides some of the information. Everything works OK, but if there is an error and an exception gets thrown when attempting to read the datareader AND the connection object remains active. To get it to work again, I have to close VS2005 and reopen the project. the linked server may be holding open the connection. If I re-run the debugger, it's as though the connection is still open and no results are returned. Testing for the connection doesn't work because it's on the server, not the local box. It's like the session created for the local running user wasn't destroyed when the error was thrown.
Is there a way to close it in code in this case or is this a linked server thing? I don't see any setting specific to debugging.
TIA,
_E
Is there a way to close it in code in this case or is this a linked server thing? I don't see any setting specific to debugging.
TIA,
_E