{"id":5623,"date":"2014-04-04T05:11:35","date_gmt":"2014-04-04T05:11:35","guid":{"rendered":"https:\/\/unknownerror.org\/index.php\/2014\/04\/04\/is-failover-partner-supported-in-system-data-sqlclient-provided-by-sql-compact-3-5-sp1-collection-of-common-programming-errors\/"},"modified":"2014-04-04T05:11:35","modified_gmt":"2014-04-04T05:11:35","slug":"is-failover-partner-supported-in-system-data-sqlclient-provided-by-sql-compact-3-5-sp1-collection-of-common-programming-errors","status":"publish","type":"post","link":"https:\/\/unknownerror.org\/index.php\/2014\/04\/04\/is-failover-partner-supported-in-system-data-sqlclient-provided-by-sql-compact-3-5-sp1-collection-of-common-programming-errors\/","title":{"rendered":"Is &quot;failover partner&quot; supported in System.Data.SqlClient provided by sql compact 3.5 sp1-Collection of common programming errors"},"content":{"rendered":"<ul>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn Hi, I&#8217;m trying to connect to SQL server from a mobile device (with WinCE 5.0). The following method<\/p>\n<pre>SqlConnection con = new SqlConnection(\"Data Source=server1;failover partner=server2;Initial Catalog=db_name; User ID =username;Password=passwd\");<\/pre>\n<p>returns ArgumentException &#8220;Unknown connection option in connection string: failover partner.&#8221; Without &#8220;failover partner&#8221; everything is ok. On device a client part (sql.wce5.armv4i.CAB) is installed from sql ce 3.5 sp1 device runtime package. How to get it working with failover partner support?<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn1 I would say no, as many other newer features are not supported, as documented here: http:\/\/msdn.microsoft.com\/en-us\/library\/aa275613(SQL.80).aspx<\/p>\n<p>No new development is being done on this component, as I understand it. You will have to use Sync or a web service\/ADO.NET Data Services\u00a0to access SQL Server with mirroring.<\/p>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>msdn Hi, I&#8217;m trying to connect to SQL server from a mobile device (with WinCE 5.0). The following method SqlConnection con = new SqlConnection(&#8220;Data Source=server1;failover partner=server2;Initial Catalog=db_name; User ID =username;Password=passwd&#8221;); returns ArgumentException &#8220;Unknown connection option in connection string: failover partner.&#8221; Without &#8220;failover partner&#8221; everything is ok. On device a client part (sql.wce5.armv4i.CAB) is installed from [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-5623","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/5623","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=5623"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/5623\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=5623"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=5623"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=5623"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}