What are the differences between SQL Native Client and SQL Native Client 10?

sql-server upgrade sqlncli
user1186256 picture user1186256 · May 10, 2012 · Viewed 16.5k times · Source

Can anyone direct me to a link or source that outlines either in general or in detail reasons to change your connection string from SQLNCLI to SQLNCLI10 when upgrading from SQL Server 2005 to 2008?

Outside of datatype issues, I am not seing any differences. I just want to have as few steps as possible with minimal complication and if there are no performance gains, or missed functionality. I just don't see the point in doing this step, at least at this moment.

Answer

user756519 picture user756519 · May 10, 2012

Below given aritcle on Microsoft SQLNCli team blog describes the differences between SQL Native Client and SQL Native Client 10.

Microsoft SQL Server Native Client and Microsoft SQL Server 2008 Native Client

Related questions

Upgrading from SQL Server 2008 R2 Express to SQL Server 2008 R2 Enterprise

When I tried upgrading from SQL Server 2008 R2 Express to SQL Server 2008 R2 Enterprise, it passed all tests and then it failed at step "Select features", saying the following error: There are no features selected for upgrade. And a window …

Read More
How do I upgrade SQL Server localDB to a newer version?

Is it possible to upgrade SqlServer localDB from 2012 to 2014? We currently use version 11 from SQL Server 2012. I need to upgrade to version 12 from SQL Server 2014. I would like to be able to do it without losing my tables and data. …

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