Updating the SQL Server Native Client 11.0 on Windows 10 Pro

Topic

New Reply

A client has device that connects by USB to a Windows 10 Pro laptop. Software installed on the laptop gathers data from the device, and sends the data across the internet via VPN to an SQL database using an ODBC connection. Everything was working on Friday but failed on Monday morning. Later on Monday I learned that at the database host they had updated software on the server which hardened the connection at their end.

So I need to update the SQL Server Native Client 11.0 on Windows 10 Pro. I had done this several years ago on Windows 7, but heck if I can remember how. As I recall, the hard part was finding the right download file on the Microsoft website. (Death by a thousand paper cuts might be preferred.) Back then, someone pointed me to a Microsoft article with the correct download file and installation instructions. At that point it was easy.

My client’s laptop has SQL Server Native Client 11.0, 2011.110.2100.60, SQLNCLI11.DLL, 2/11/2012.

Network support at the database host says that SQL Server Native Client 11.0, 2011.110.7001.00, SQLNCLI11.DLL, 8/15/2017, works for them in their test environment. The article that they pointed me to is regarding SQL Server, but not the Client, so doesn’t seem right to me. Or is it?
https://www.microsoft.com/en-us/download/details.aspx?id=50402

Can anyone point me in the right direction to find the SQL Server Native Client that I need?

Reply | Quote

Replies

There is more information on the SQL Server Native Client here. along with what seems to be information about installing only the client component.

When you invoke sqlncli.msi, only the client components are installed by default. The client components are are files that support running an application that was developed using SQL Server Native Client.

 

Reply | Quote

Aha! Thanks PKCano! I’m putting some pieces together. I have also learned that the database is running on SQL Server 2016. But the link that I got from tech support was for SQL Server 2012 – which had me puzzled.

But there was some additional important detail from the link that you provided: “There is no SQL Server 2016 Native Client.”

So I have a couple of sqlncli.msi files to try. One from the link they sent me and one from the link you provided. Something tells me they’re different, but let you know what I learn next.

Reply | Quote

Tchalms wrote:

Aha! Thanks PKCano! I’m putting some pieces together. I have also learned that the database is running on SQL Server 2016. But the link that I got from tech support was for SQL Server 2012 – which had me puzzled.

I think that link deals with that part too.
Did you expand the sections on the Download site in your link?

1 user thanked author for this post.

Tchalms

Reply | Quote

The link above:
https://www.microsoft.com/en-us/download/details.aspx?id=50402
included the correct msi file. I downloaded it, installed it and had the right driver.

Easy and fun. And it worked.

Thanks PKCano!

 

Reply | Quote

Yes.. it worked for me as well. Thanks for the direct link to download.

Reply | Quote

By the way the download link installs below sql client version:
2011.110.7001.00 sql server native client

Reply | Quote