sql server - SQL OLEDB provider: connection string to Failover partner -


we're trying connect sql database mirroring enabled. have 2 servers: db1 (principal) , db2 (mirror).

we're using connection string:

provider=sqloledb;data source=db1;failover partner=db2;database=databasename;uid=username;pwd=password; 

when db1 in principal role, works ok. but, when db1 goes down, , db2 (mirror) becomes principal, receive error:

invalid connection string attribute

we tried change data source server name ip, ip:1433... without success. tried change parameter "failover partner" "failoverpartner", without success.

is possible connect db mirror sqloledb provider @ all?

you need use sql native client or ado.net, not sqloledb not support failover partner parameter.


Comments

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

php - Nothing but 'run(); ' when browsing to my local project, how do I fix this? -

php - How can I echo out this array? -