OnConnectionLost Issue

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 5
Joined: Thu 11 Sep 2008 02:58

OnConnectionLost Issue

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
Microsoft SQL Server: 09.00.1399
Microsoft SQL Native Client: 9.00.1399.06


Devart Team
Posts: 925
Joined: Thu 17 Nov 2005 10:53

Post by Challenger » Mon 20 Oct 2008 13:10

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

Post Reply