SQL Server Express Instance in ODBC Driver

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

Introduction

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

Syntax

 Driver={SQL Server Native Client 10.0};Server=.\SQLExpress;AttachDbFilename=c:\database\project\file1.mdf; Database=dbname;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

© 2019 DotNetHeaven. All rights reserved.