Page 1 of 1

How to detect Connection lost

Posted: Mon 02 Nov 2009 13:36
by garry
Hello

How can i detect whether the connection is lost or not?
I tried with OnConnectionLost event of TMSConnection..but seems not working..is there any prerequisite to activate OnConnectionLost.

Well, My objective to is to detect connection lost so i can stop query operations running timely in my application to avoid unnecessary exceptions.
Thanks

Posted: Mon 02 Nov 2009 13:52
by Dimon
The OnConnectionLost event is arised when the TMSConnection.Options.LocalFailover property is set to True.

Connection lost

Posted: Mon 14 Dec 2009 19:38
by ccmcbride
Okay, I set my localFailover = true, but I am getting a ton of errors before the 'onconnectionlost' event is finally hit.
Is there anything else to look at?

I am connected locally, and I am shutting down sqlserver purposely in an attempt to create the error for client sites...
Note : I have autorefresh turned on.

Posted: Tue 15 Dec 2009 08:01
by Dimon
I can not reproduce the problem. Please try to compose a small sample to demonstrate the problem and send it to dmitryg*devart*com.