SQL Server Instance in ODBC Driver

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

Introduction

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

Syntax

 Driver={SQL Server Native Client10.0};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

© 2019 DotNetHeaven. All rights reserved.