CodeSmith Community
Your Code. Your Way. Faster!

SQL Server Failover

Latest post 12-01-2006 11:34 AM by Robert Hinojosa. 1 replies.
  • 11-30-2006 12:34 PM

    • zkent
    • Top 50 Contributor
    • Joined on 11-16-2004
    • Colchester, VT, USA, N. America, Earth....
    • Posts 83
    • Points 1,455

    SQL Server Failover

    I am using 0.9.2 (Caribert).  Is there (in this version or the current one) a method for specifying two connections strings for SQL Server mirroring?  I recently set up my primary SQL server and a mirrored secondary SQL server with automated failover.  Is anyone else doing this and is there anything built into .netTiers?
    Zachary Kent
    Director of IT

    R. J. Peters Associates, Inc.

    www.avmax.net
    • Post Points: 35
  • 12-01-2006 11:34 AM In reply to

    Re: SQL Server Failover

    Hi,

    No, not out of the box.  In the new one though, you could just configure two providers with two different connection strings.  Then when you catch a sql exception you can have some class that will always fetch you the current provider.  This shouldn't be that difficult to implement.
     


    Robert Hinojosa
    -------------------------------------
    Member of the Codesmith Tools, .netTiers, teams
    http://www.nettiers.com
    -------------------------------------
    • Post Points: 5
Page 1 of 1 (2 items) | RSS
Copyright © 2008 CodeSmith Tools, LLC
Powered by Community Server (Commercial Edition), by Telligent Systems