How to Use SQL Server Instance in OLE DB Provider

In this article I am going to explain about how to create connection string using SQL server instance in SQL server native client 10.0 OLE DB provider.
  • 2180

Introduction

Here I am explaining  how to create connection string  using SQL server instance and express instance in SQL server native client 10.0 OLE DB provider. To create connection string  using SQL server instance in SQL server native client 10.0 OLE DB provider we need to put provider, your instance name, your database name and set the state of trusted connection to yes.

Syntax

 Provider=SQLNCLI10;Server=urServerName\theInstanceName;Database=urDataBase;Trusted_Connection=yes;     


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.