VN2008
asked on
MS SQL 2008 Mirroring and MS Access Frontend
Hi Expert!
I have MS SQL Server 2008 Developer Edition.
The Mirroring is configured and works fine for .Net Applications.
See for example http://msdn.microsoft.com/en-us/library/5h52hef8.aspx for using Mirroring in ADO.NET
But we have also MS Access Frontend Applications. How to use the mirroring in this case? Where the second copy of the database must be configured?
I have MS SQL Server 2008 Developer Edition.
The Mirroring is configured and works fine for .Net Applications.
See for example http://msdn.microsoft.com/en-us/library/5h52hef8.aspx for using Mirroring in ADO.NET
But we have also MS Access Frontend Applications. How to use the mirroring in this case? Where the second copy of the database must be configured?
ASKER
Hi cyberkiwi!
Thanks for the replay.
I set the connection in the Data Link Properties Dialog
DataLinkProperties.gif
Thanks for the replay.
I set the connection in the Data Link Properties Dialog
DataLinkProperties.gif
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi cyberkiwi,
Thank you!
We will check this possibillity and i will replay, after the test is done
Thank you!
We will check this possibillity and i will replay, after the test is done
If it is an ODBC DSN, you can add the directive
Failover Partner=PartnerServerName
into the DSN, e.g.
[ODBC]
DRIVER=SQL Server
DATABASE=dbname
Trusted_Connection=Yes
SERVER=servername
Failover Partner=PartnerServerName