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
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