[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