Determine when server is unavailable
- From: "sklett" <sklett@xxxxxxxxxxxx>
- Date: Thu, 13 Apr 2006 10:59:46 -0700
I need to support "offline operation" - that is, if the DB server for
whatever reason is unavailable (network communication down, server crashed,
someone cut the users cat5, etc) I need to store the data locally until
communication is restored at which point I will catch-up on a worker thread
and update everything.
My problem is determining when the server is unavailable. I have tried to
come up with a clever process to catch events and exceptions that would
indicate loss of server availability, but they end up being a little too all
encompassing. In other words, I want avoid a bug on my part throwing an
exception and being treated as a server outage.
I guess I could resort to running Reg. Expressions on the exception message?
Have any of you had to implement something like this? If so, how did you
handle this?
Thanks,
Steve
.
- Follow-Ups:
- Re: Determine when server is unavailable
- From: Otis Mukinfus
- Re: Determine when server is unavailable
- Prev by Date: Re: Currency,Decimal,Access and Confusion
- Next by Date: Accessing Application Settings Created In VS2005 Designer
- Previous by thread: Re: maintaining case while inserting GUIDs into SQL Server tables
- Next by thread: Re: Determine when server is unavailable
- Index(es):
Relevant Pages
|
|
