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