Is "failover partner" supported in System.Data.SqlClient provided by sql compact 3.5 sp1-Collection of common programming errors

12 years ago

admin

1 minute

msdn Hi, I’m trying to connect to SQL server from a mobile device (with WinCE 5.0). The following method
```
SqlConnection con = new SqlConnection("Data Source=server1;failover partner=server2;Initial Catalog=db_name; User ID =username;Password=passwd");
```
returns ArgumentException “Unknown connection option in connection string: failover partner.” Without “failover partner” 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?
msdn1 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

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 to access SQL Server with mirroring.