SQL native client

Question

SQL native client

W Raspe 21

Is there any newer version of native client to use for SQL server 2019?
I cannot find any newer version.

Accepted answer

2 additional answers

Your answer

Answer 1

Garth Jones 1,666 MVP

There warning is for the Server OS not SQL versions.

W Raspe 21 Reputation points

2022-10-14T18:51:26.427+00:00

I am using server 2022 datacenter
Yitzhak Khabinsky 26,586 Reputation points

2022-10-14T19:04:52.883+00:00

@W Raspe ,

I explained in my answer what driver to install and use on your server.
Garth 5,801 Reputation points

2022-10-15T00:07:14.893+00:00

review the logs to see what server is seen as win2012. if the server is correct then ignore the warning for now.
W Raspe 21 Reputation points

2022-10-15T09:14:46.163+00:00

it was not needed, since SQL server 2017 installed the Native 2012 client and it needs to work on that.

Answer 2

Yitzhak Khabinsky 26,586

Hi @W Raspe ,

All Microsoft OLEDB providers are deprecated, and NOT recommended to be used, except Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL).
Check it out here: oledb-driver-for-sql-server

Answer 3

Erland Sommarskog 121.4K MVP Volunteer Moderator

SQL Native Client was a combined DLL for ODBC and OLE DB. OLE DB got deprecated, which ended that co-habitation. Later, OLE DB was un-deprecated.

The most recent ODBC driver is ODBC Driver 18 for SQL Server.

The most recent OLE DB driver is Microsoft OLE DB Driver 19, MSSQLOLEDB19.

Share via

SQL native client

2 additional answers

Your answer