You can't can't specify the failover partner in the connection string? That's how we did it for the PeopleSoft HR and Finance systems at a previous employer.

No changes to the actual application.