How to Use Express Instance in OLE DB Provider

In this article i will explain how to Use Express Instance in OLE DB Provider.
  • 1594
Introduction

Here I am explaining  how to create connection string  using express instance in SQL server native client 10.0 OLE DB provider.

SQL Server Express Instance

To create connection string using SQL server instance in SQL server native client 10.0 OLE DB provider we need to put provider, path and file name of instance, your database name, set the state of Trusted connection to true.

 Provider=SQLNCLI10;Server=.\SQLExpress;AttachDbFilename=c:\database\project\file1.mdf;Database=urdbname; Trusted_Connection=Yes;

Further Readings

You may also want to read these related articles :

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.