[Mono-list] Mono does support "Failover Partner" ?!
Josef Semmler
josef.semmler at gmail.com
Wed Feb 1 13:26:26 UTC 2012
Hello,
maybe i'm just to stupid:
Is it possible that mono really does not support "Failover Parnter" for
database connection strings?
I have the following code
using System.Data.SqlClient;
namespace DBFailoverTest
{
class Program
{
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))
{
connection.Open();
SqlCommand queryCommand = new SqlCommand("SELECT 1"
, connection);
SqlDataReader queryCommandReader = queryCommand.
ExecuteReader();
}
}
}
}
Using mono 2.6.7 i only get:
C:\DBFailoverTest\bin\Debug>mono DBFailoverTest.exe
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!?
Is there a workaround? Or does it really not work?
thanks
JS
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ximian.com/pipermail/mono-list/attachments/20120201/706f5609/attachment.html>
More information about the Mono-list
mailing list