How to Use Database Mirroring in OLE DB Provider

This article explains the connection string used to create database mirroring in OLE DB Provider.
  • 2105

The process of copying data from one location to another storage device in real-time is known as Database mirroring. It is useful in recovery of data after disaster. To create connection string  with database mirroring in SQL server native client 10.0 OLE DB provider we need to put provider, your server address, your mirror server address,  your database name, set the state of Integrated security to true.

Syntax:

Provider=SQLNCLI10;Data Source=urServerAddress;Failover Partner=urMirrorServerAddress;Initial Catalog=urDataBase;Integrated Security=True;

Ask Your Question 

Got a programming related question? You may want to post your question here

Programming Answers here

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.