Page 1 of 1

Example of LocalFailOver in Service Application

Posted: Wed 18 May 2016 02:19
by coder6910
Do you have an example of using TMS.options.localfailover in a service application? I have a thread that inserts data into SQL Server and would like to use this option to ensure the service can recover from a connection loss. More specifically how do I handle the OnConnectionLost event?

Thanks,
Pat

Re: Example of LocalFailOver in Service Application

Posted: Wed 18 May 2016 10:34
by azyk
SDAC includes FailOver demo project of desktop application, showing how to use the TMSConnection.Options.LocalFailover property and handle the OnConnectionLost event. You can use this demo parts in your service project.

The FailOver demo project is in the "Demos\Miscellaneous\FailOver\" folder, relatively to the SDAC demo projects installation path.

In addition, we recommend to read the Working in an Unstable Network article in our help: http://www.devart.com/sdac/docs/index.h ... etwork.htm

If you have any questions remained after acquaintance with the article and investigation of the demo project, or new questions appear, please ask - we will answer them.