Devart Forums

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.

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

Thanks for the clarification.

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.

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

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.