locked
DataBase Mirroring with Classic ASP RRS feed

  • Question

  • Greetings
     
    I'm trying to implement Database Mirroring on my SQL Server 2005 SE. The front end is a classic ASP application.
    Would it be possible to implement Automatic Failover? If yes, any help with the connection string and Native Client is greatly appreciated?


    Thank you
    AE, MCTS
    Monday, February 2, 2009 3:22 PM

Answers

  • Hi Abdshall,

    I don't know much about classic ASP, but mirroring's automatic failover is only supported on three providers (per BOL):

    SQL Native Client

    ADO.NET 2.0 provider for SQL Server 2005 (SqlClient)

    SQL Server 2005 JDBC (Java Database Connectivity) 1.1 Driver

     

    If your classic ASP app can use one of these three, then yes, you can use automatic failover.  The provider handles the failover automatically - all you need to do is add a "failover partner" element to your connection string:

    ;Failover Partner=MyMirrorServer;

     

    Is this what you're looking for?


    Aaron Alton | thehobt.blogspot.com
    • Marked as answer by Abdshall Wednesday, March 25, 2009 1:29 PM
    Tuesday, February 3, 2009 3:06 AM