SqlClient NET Data Provider 1.1 and MSSQL 2005  
Author Message
A. Emtsov





PostPosted: .NET Framework Data Access and Storage, SqlClient NET Data Provider 1.1 and MSSQL 2005 Top

Hi,

Is The SqlClient .NET Data Provider from in the Microsoft .NET Framework, Version 1.1. support SQLNCLI or I should use OleDbConnection if i want to use MSSQL 2005 features like MARS

Thanks!



.NET Development35  
 
 
Bill Lin - MSFT





PostPosted: .NET Framework Data Access and Storage, SqlClient NET Data Provider 1.1 and MSSQL 2005 Top

ADO.NET 1.1 (Including SqlClient, OleDb, Odbc providers) uses MDAC to communicate with Sql Server. You must install 2.0 to use the new SQL 2005 features like MARS.

You can also get those new features with SQL Native Client if you are using OLE DB or ODBC (applications using native-code APIs). You indicate you want MARS support by using the connection string "MARS Connection=True". In ADO, you can also use "Provider=SQLNCLI;MARS Connection=True" in the connection string.

OleDbConnection is merely a class of ADO.NET managed provider.