This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Learn More

Remove From My Forums

SQL Server Native Client 11.0 support for SQL Server 2019

Question
0

Sign in to vote
From the below document it looks like SQL Native Client 11.0 does not support connection to SQL Server 2016 and above.

https://docs.microsoft.com/en-us/sql/relational-databases/native-client/applications/support-policies-for-sql-server-native-client?view=sql-server-ver15

“SQL Server Native Client 11.0 supports connections to, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 (11.x), SQL Server 2014 (12.x), and Azure SQL Databases"

Connection to SQL Server 2019 using Native Client 11.0 works in some environments and fails in another.

Could you please clarify whether Native Client 11.0 supports connection to SQL Server 2019.
Thursday, May 21, 2020 3:35 AM

All replies

0

Sign in to vote
Hi Ash46,

I did not found any MS official document clarify whether Native Client 11.0 supports connection to SQL Server 2019. I can only get the information that you have got.

From Microsoft® ODBC Driver 11 for SQL Server download link.

Microsoft ODBC Driver 11 for SQL Server is a single dynamic-link library (DLL) containing run-time support for applications using native-code APIs to connect to Microsoft SQL Server 2005, 2008, 2008 R2, SQL Server 2012, SQL Server 2014 and Windows Azure SQL Database.
According to MS document, the SQL Server Native Client (SQLNCLI) remains deprecated and it is not recommended to use it for new development work. Instead, use the new Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) which will be updated with the most recent server features.

I found you have opened a thread in MS official document feedback. I suggest you waiting for the reply from author.

Best regards,
Cathy

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com
- Edited by Cathy JiMicrosoft contingent staff Thursday, May 21, 2020 7:41 AM
- Proposed as answer by Cathy JiMicrosoft contingent staff Monday, May 25, 2020 7:56 AM
Thursday, May 21, 2020 7:31 AM
0

Sign in to vote

Thank you Cathy. I will wait.

Thursday, May 21, 2020 9:22 AM
0

Sign in to vote

Hi Ash46,

Waiting for your good news.

Best regards,
Cathy
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

Friday, May 22, 2020 1:35 AM