CODEWITHSUNDEEP
sql-serversql-server-native-client
StackTrace
StackTrace

Reputation: 9416

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

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?

Upvotes: 3

Views: 17564

Answers (2)

Brian Watt
Brian Watt

Reputation: 235

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.

Upvotes: 4

Asghar
Asghar

Reputation: 51

SQLNCLI11.1 as the version number suggest is an update of SQLNCLI11. I am not familiar with the list of upgrades .1 provides but it has resolved some of the errors I was encountering in my SSIS package.

E.g. Error 0x80004005 Description: "Communication link failure".

Once I upgraded the connection to 11.1 the error was gone. The above error is one of the bugs that I assume has been fixed in the later version.

Upvotes: 0

Related Questions