none
Unable to connect to Failover with SQLOLEDB provider

    Question

  • We have a mirrored configuration and everything appears to work correctly.  However, our app is unable to connect to the mirror when it fails over. It fails using the following connect string.  

    ConnectString = Provider=SQLOLEDB.1;Persist Security Info=False;User ID=ouruser;Password=ourpassword;Initial Catalog=ourcatalog;Data Source=10.1.137.50;Network=dbmssocn;FailoverPartner=10.1.137.49

    If we use the SQLNCLI provider it works perfectly without changing anything else.  My question is twofold.  

    1.  Is it possible to use the SQLOLEDB provider?

    2.  If not, is there any danger in using the SQLNCLI provider with an app that was built using SQLOLEDB. Everything I can find seems to point to SQLNCLI being an extension of SQLOLEDB and being completely backward compatible.  

    Thanks for any insight you can provide.

    Wednesday, April 13, 2011 12:52 PM

Answers

  • This problem occurs because the SQL Native Client OLE DB provider and the SQL Native Client ODBC driver do not correctly translate the alias to an IP address before the .NET Framework-based application tries to connect to the mirror partner server.

    Pleae check this url http://support.microsoft.com/kb/941526
    http://uk.linkedin.com/in/ramjaddu
    Wednesday, April 13, 2011 2:08 PM