Determine when server is unavailable

[sklett]

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

 

[Otis Mukinfus]

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

Take a look at Messaging in the help files (Message Queuing).

That's the way to use store forwarding.

Good luck with your project,

Otis Mukinfus
http://www.arltex.com
http://www.tomchilders.com