Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
- Posts: 5
- Joined: Thu 11 Sep 2008 02:58
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
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 18.104.22.168
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
Please refer to the article "Working in an unstable network" in the SDAC help.