Does ADO.NET support multi-subnet failover for SQL connections, and how does this feature compare to ODBC's multi-subnet failover support?

YONG Chee Wee 1 Reputation point

I am using ADO.NET for SQL connections. Does ADO.NET support multi-subnet failover? I understand that ODBC supports multi-subnet failover. Can you explain the difference between ADO.NET and ODBC in this regard?

Microsoft Technologies based on the .NET software framework.
3,545 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,121 questions
Windows Network
Windows Network
Windows: A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.Network: A group of devices that communicate either wirelessly or via a physical connection.
687 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Erland Sommarskog 104.2K Reputation points MVP

    Depends on what you mean with ADO .Net, but I will assume that you mean SqlClient. And, yes, SqlClient suppotrs MultiSubnetFailover, see

    I would expect any differences between SqlClient and ODBC with regards this connection-string property. But since they are different implementations, there may be subtle differences.