Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Database Mirroring FAQ: Is Mirroring Supported by MS Access front-end?

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.

New Data Source

Specify Failover Partner

Comments

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

Leave a Comment

Please register or log in to leave a comment.