Connection error

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
tcflam
Posts: 60
Joined: Tue 01 Jan 2013 10:48

Connection error

Post by tcflam » Mon 03 Feb 2020 09:51

Hi,

I'm using XE2 and SDAC 8.2.8. Around half year ago, my application can't connect the SQL server suddenly. DB server is keeping in China and users are using in HK. I tried to using different port in firewall and redirect to 1433. But it also always fail to connect. How can solve it? Need it to use 3-tier (datasnap) solve this problem? Any example for datasnap?

Thanks.
Timothy

Stellar
Devart Team
Posts: 347
Joined: Tue 03 Oct 2017 11:00

Re: Connection error

Post by Stellar » Thu 06 Feb 2020 10:52

SDAC supports disconnected mode. In disconnected mode, a connection opens only when it is required. After performing all server calls, connection closes automatically until the next server call is required. Datasets remain opened when connection closes.

For more information on the disconnected mode, please refer to our online documentation:
devart.com/sdac/docs/work_disconnectmode.htm

You can find the demo project in the %SDACDemos%\ directory. %SDACDemos% is the path to the installed demo projects on your computer.
The CachedUpdates tab shows a sample of how to use disconnected mode.

Post Reply