| Subject: | SQL Server Failover |
| Posted by: | John Friel III (jo…@frieltek.com) |
| Date: | Thu, 30 Oct 2008 |
Using RAD Studio 2007, SQL Server 2005 on two different servers.
My current application is running fine on the first server. I have
successfully setup a Mirror of the database with a Witness Server watching.
I tried using the following connection UDL file but it would not failover to
the second server. Can the mirrored server be used without failing the
primary server? In my testing, I removed access to the primary from my
workstation to see if my program still ran.
UDL File:
[oledb]
; Everything after this line is an OLE DB initstring
Provider=SQLOLEDB.1;Password=xxxxxxx;Persist Security Info=True;User
ID=sa;Initial Catalog=ProParts;Data Source=BONDO;FailoverPartner=CRM
Any tips for using Delpi, ADO and mirrored servers is appreciated.
Thanks
John