Subscribe to this blog
Briefcase
Print
Question: Is Mirroring Supported by MS Access front-end?
The following question was posted on a SQL Server discussion group. My reply follows.
Is the MS SQL Mirroring supported by MS Access Frontend (.adp) ?
We 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?
My answer:
In order to specify the mirroring partner, you have to use the SQL Server Native Client 10.0 client for the DSN and specify the database name for the connection. The generic SQL Server DSN interface doesn’t support it.
Posted by Anonymous on 7 May 2010
Pingback from Twitter Trackbacks for SSC Blog - Database Mirroring FAQ: Is Mirroring Supported by MS Access front-end?: Question: Is Mirroring Supporte... [sqlservercentral.com] on Topsy.com
Posted by Anonymous on 7 May 2010
Pingback from Where is a good, free ASP.NET website hosting site? | BingSite
Posted by Anonymous on 8 May 2010
Pingback from Connection string for the web host on sql server?help? | BingSite
Posted by Anonymous on 12 May 2010
Pingback from Web Mirroring Service at Bns Hosting | Web Hosting and Web Design For Small Business