Announcement

Collapse
No announcement yet.

Sql Server Failover Partner

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Sql Server Failover Partner

    Hi,

    Does any one know if Mirth supports the SQL 2005 Failover Partner config in the connnection string?

    Thanks

  • #2
    Re:Sql Server Failover Partner

    For Future Reference,

    I installed the microsoft.jdbc driver 1.2 and added the failoverPartner= into the connection string and it worked like a charm.

    Comment


    • #3
      I have added sqljdbc4-2.0.jar file in custom-lib folder and added the driver in dbdrivers.xml file.

      <driver class="com.microsoft.sqlserver.jdbc.SQLServerDrive r" name="SQL Server 2012" template="jdbc:sqlserver://hostort;databaseName=dbName;failoverPartner=dbNa me" selectLimit="SELECT TOP 1 * FROM ?" />

      Used the same driver to call the connection and was able to connect to failoverPartner when primary is down.

      var url = "jdbc:sqlserver://xx.xx.x.xx;DatabaseName=xxx;failoverPartner=xx.xx. x.xx";
      var driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver" ;

      --
      Arun
      Last edited by gouvearun; 09-06-2016, 01:20 AM.

      Comment

      Working...
      X