I have the following code
static void Main(string args)
string connectionString = "Data Source=server1;Failover Partner=server2;Initial Catalog=testdb;Persist Security Info=True;User ID=user;password=letmein";
using (SqlConnection connection = new SqlConnection(connectionString))
SqlCommand queryCommand = new SqlCommand("SELECT 1", connection);
SqlDataReader queryCommandReader = queryCommand.ExecuteReader();
Using mono 2.6.7 i only get:
Unhandled Exception: System.ArgumentException: Keyword not supported : 'failover partner'.
at System.Data.SqlClient.SqlConnection.SetProperties (System.String name, System.String value) [0x00000] in <filename unknown>:0
Same with mono 2.10.x
I also checked the code on githup ... and although the values seem to be there - it seems as if the "SetProperties" method does not support this option!?
Anything new on it?
I ran into this issue on Ubuntu 14.04 with xsp webserver and .Net Framework 4 and SQL Server 2005
Having the same issue:
This also doesn't support multisubnetfailover.
For some reason the docs say its supported:
Either the docs should be update to reflect this is not supported, or the code should change.
System.Data is moving to corefx sources where the 'Failover Partner' and 'multisubnetfailover' keywords are fully implemented.