Page 1 of 1

Connection error

Posted: Mon 03 Feb 2020 09:51
by tcflam
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

Re: Connection error

Posted: Thu 06 Feb 2020 10:52
by Stellar
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.