Would like to upgrade SQL server 2012 native client to latest

Question

Hi,

We would like to upgrade SQL server 2012 native client to latest. I can see, It is recommended to upgrade to Microsoft OLE DB driver. We are supporting SQL server 2016 and 2019. Can you please suggest the recommended latest SQL native server client upgrade and also share the process and its impacts.

Thanks,

Answer 1

Hi JamesJ-9502,
How are things going?

We would like to upgrade SQL server 2012 native client to latest.

For the latest update for SQL Server 2012 Native Client, you can download it from this link. And as Erland mentioned, if you have SQL Server 2012 SP4, you already have the latest update.

It is recommended to upgrade to Microsoft OLE DB driver.

You can download Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) from this link. In addition, please refer to Connection String Keywords with OLE DB Driver which might be helpful.
Best Regards,
Amelia

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

What does "SELECT @@version" return?

If you have SQL 2012 SP4 and the last CU for SQL 2012 SP4, you already have the latest version.