What is the difference between SQL Server Native Client SQLNCLI11 & SQLNCLI11.1?

sql-server sql-server-native-client
StackTrace picture StackTrace · May 5, 2015 · Viewed 14.4k times · Source

I'm having a look at a connection string with Provider=SQLNCLI11 and another one with Provider=SQLNCLI11.1 & i'm wondering what the difference between the two is.

What is the difference between SQLNCLI11 & SQLNCLI11.1?

Answer

Brian Watt picture Brian Watt · May 5, 2016

Per this TechNet article the two versions point to the same CLSID under HKEY_CLASSES_ROOT. Thus they point to the same DLL. SQLNCLI11 is the version indpendent ProgID.

Depending on what Microsoft does when SQLNCLI11.2 comes around, it may be better to use the one without the ".1", although they could just as easily make .1 point to .2 when they release the update.

Related questions

Using SQL Server Native Client to access SQL Server LocalDB

I'm trying to connect to a SQL Server LocalDB instance using the SQL Server Native Client driver. This is because we are looking to use Native Client in our production environment to gain access to the use of subject alternative …

Read More
Connection string for SQL Server native client in ASP.NET web.config

I want to connect to SQL Server 2012 using SQL Server native client from my ASP.NET application. Currently, I have one existing connection string connect using odbc and working fine. <appSettings> <add key="StagingConnect" value="Integrated Security=…

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More