SQL Native Client Connection String in .NET Framework

In this article, I will explain How to create SQL Native Client Connection String in .NET Framework
  • 2190

SQL Native Client ODBC Driver in .NET

Introduction

  • The .NET Framework Data Provider for ODBC uses native ODBC Driver Manager through COM .

  • The OdbcConnection bridges to the underlying driver specified in the connection string using the keyword "Driver" or "DSN".

  • Every ODBC driver can be used through this class library.

  • The .NET Framework Data Provider for ODBC supports both local and distributed transactions.

  • This is a .NET Framework Wrapper Class Library provided by Microsoft.

  • The wrapper class library is contained in the file System.Data.dll.

To create connection string to SQL native client in .NET framework data Driver for ODBC we need to put provider, your server address, your database, your user name and password.

Syntax

Driver={SQL Server Native Client 10.0; Server=UrServerAddress;Database=UrDataBase;Uid=UrUsername;Pwd=UrPassword;

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.