In my application SQL Server 2019 is already supported, I want to it will support SQL Server 2022 also and ODBC 18 driver. For this scenario does SQL Server Native Client comes into any kind of role.

Question

In my application SQL Server 2019 is already supported, I want to it will support SQL Server 2022 also and ODBC 18 driver. For this scenario does SQL Server Native Client comes into any kind of role. If yes then what is that. Do I need to install SQL Server Native Client on mandatory basis or no need to install to use the application.

Answer 1

Hi，Mahesh Kumar

You do not need to install SQL Server Native Client.

The SQL Server Native Client (often abbreviated SNAC) has been removed from SQL Server 2022 (16.x) and SQL Server Management Studio 19 (SSMS). The SQL Server Native Client (SQLNCLI or SQLNCLI11) and the legacy Microsoft OLE DB Provider for SQL Server (SQLOLEDB) are not recommended for new application development. Switch to the new Microsoft OLE DB Driver (MSOLEDBSQL) for SQL Server or the latest Microsoft ODBC Driver for SQL Server going forward. For SQLNCLI that ships as a component of SQL Server Database Engine (versions 2012 through 2019), see this Support Lifecycle exception.

Refer to this.

Information：

https://learn.microsoft.com/en-us/sql/connect/odbc/microsoft-odbc-driver-for-sql-server?view=sql-server-ver15

Download：

https://learn.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver16&source=recommendations

Best Regards,

Mikey Qiao

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 2

Additional see Driver history for Microsoft SQL Server