Data Directory SQL Server Express Instance in ODBC Driver

In this article I am going to explain about how to use data directory SQL server express instance in ODBC Driver.
  • 2359

Introduction

Here I am explaining  how to use data directory SQL server express instance in SQL server native client 10.0 ODBC Driver.

To create connection string using the data directory SQL server express instance in SQL server native client 10.0 OLE ODBC Driver we need to put provider, file name , your database name, set the state of Trusted connection to true.

Syntax

 Driver={SQL Server Native Client10.0};Server=.\SQLExpress;AttachDbFilename=|DataDirectory|urdbfile.mdf;Database=dbname;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.