MultiSubnetFailover

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
yeohray2
Posts: 14
Joined: Thu 08 May 2014 15:49

MultiSubnetFailover

Post by yeohray2 » Mon 25 Jul 2016 15:23

If I want to add MultiSubnetFailover=True as part of the SQL Server connection string, how do I do that? I'm working in a high-availability scenario, and while I can see a ApplicationIntent property for TMSConnection, I don't see a property for MultiSubnetFailover. For reference purposes - https://msdn.microsoft.com/en-us/librar ... .110).aspx

Thanks in advance.

ViktorV
Devart Team
Posts: 2299
Joined: Wed 30 Jul 2014 07:16

Re: MultiSubnetFailover

Post by ViktorV » Tue 26 Jul 2016 10:10

SDAC doesn't support the MultiSubnetFailover option, since we use OLEDB or NativeClient when working with SQL Server, and they don't support this option: http://msdn.microsoft.com/en-us/library/gg471494.aspx

yeohray2
Posts: 14
Joined: Thu 08 May 2014 15:49

Re: MultiSubnetFailover

Post by yeohray2 » Tue 26 Jul 2016 15:00

Thanks for the clarification.

ViktorV
Devart Team
Posts: 2299
Joined: Wed 30 Jul 2014 07:16

Re: MultiSubnetFailover

Post by ViktorV » Wed 27 Jul 2016 09:26

If you have any questions while using our products, please don't hesitate to contact us - and we will try to help you resolve them.

Hooman
Posts: 8
Joined: Wed 30 Jan 2013 18:53

Re: MultiSubnetFailover

Post by Hooman » Wed 20 Dec 2017 22:25

Hi,

Based on the following link from Microsoft, Native Client 2012 is able to support "Always On" feature.

https://docs.microsoft.com/en-us/sql/re ... r-recovery

Can you please specify the properties that needs to be done on SDAC?

Thanks

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

Re: MultiSubnetFailover

Post by Stellar » Fri 18 May 2018 09:48

Unfortunately, SDAC does not support the MultiSubnetFailover parameter, as we use OLEDB when working with NativeClient.
OLE DB in the SQL Server Native Client does not support the MultiSubnetFailover keyword.

Post Reply