Detect Dead Connection

  • I've built a VB application which simulates being multithreaded through giving each operation a timeslice to do it's work, then moving onto the next part.

    Because of the occassional hiccup on the network, I've moved away from the Open 1 connection, and use that, to the more Internet Style connections where you open, do, close connection.

    I really want to move back to the original plan of 1 connection, BUT I want to make sure that the connection is still operational before doing something with it. Is there a smart way to do it?

  • If you're using ADO you could declare your connection withevents - then you can monitor for the connectionbroken event. Probably just as good is to assume the connection is good, if not trap the error and try to reopen.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply