连接镜像服务器

SqlConnectionStringBuilder sqlsb = new SqlConnectionStringBuilder(); sqlsb.DataSource = "ServerA"; sqlsb.FailoverPartner = "ServerB"; sqlsb.UserID = "XXX"; sqlsb.Password = ""; sqlsb.InitialCatalog = "DataBase"; SqlConnection sqlconn = new SqlConnection(); sqlconn.ConnectionString = sqlsb.ConnectionString; String ActiveServer = sqlconn.DataSource;
posted @ 2017-03-05 00:00  PhilXu  阅读(137)  评论(0)    收藏  举报