OnConnectionLost Issue

yulianto · Post by **yulianto** » Mon 20 Oct 2008 03:55

I am building an application on an unstable network. How can I detect if i lost connection to the server in middle of - let's say - inserting process?
I need to know whether my application is still connected when i press POST button.

I have put simple logic on TMSConnection.OnConnectionLost

Code: Select all

RetryMode:= rmReconnectExecute;

I've also turned on the localFailover option, but the connectionlost didn't fired up. i got error "shared memory provider: no process is on the other end of the pipe" and "cannot performed this on closed dataset"

I am using BDS 2006 and SDAC 4.50.0.35
Microsoft SQL Server: 09.00.1399
Microsoft SQL Native Client: 9.00.1399.06

Thanks.

Challenger · Post by **Challenger** » Mon 20 Oct 2008 13:10

Please refer to the article "Working in an unstable network" in the SDAC help.