SQL Server AlwaysOn

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
PhilippS
Posts: 2
Joined: Fri 17 Aug 2018 08:02

SQL Server AlwaysOn

Post by PhilippS » Fri 17 Aug 2018 08:06

Hello

Is SQL Server AlwaysOn supported by UniDAC?

Thanks

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

Re: SQL Server AlwaysOn

Post by Stellar » Mon 20 Aug 2018 12:55

UniDAC supports SQL Server Always On when using the prNativeClient provider. For this, set the special Provider option for TUniConnection to prNativeClient. To configure the connection, you can set the following options:
- ApplicationIntent. Declares the application workload type when connecting to a server. Possible values are aiReadOnly and aiReadWrite.
- FailoverPartner. Name of the failover partner server to be used if a connection cannot be made to the primary server.

PhilippS
Posts: 2
Joined: Fri 17 Aug 2018 08:02

Re: SQL Server AlwaysOn

Post by PhilippS » Tue 21 Aug 2018 06:41

Thanks for the answer!

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

Re: SQL Server AlwaysOn

Post by Stellar » Tue 21 Aug 2018 07:48

Thank you for the interest in our products.
Please contact us if you have any questions about our products.

Post Reply