News, tips, advice, support for Windows, Office, PCs & more
Home icon Home icon Home icon Email icon RSS icon

We're community supported and proud of it!

  • Updating the SQL Server Native Client 11.0 on Windows 10 Pro

    Home Forums AskWoody support Windows Windows 10 Questions: Win10 Updating the SQL Server Native Client 11.0 on Windows 10 Pro

    Viewing 2 reply threads
    • Author
      Posts
      • #2381605
        Tchalms
        AskWoody Plus

        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?

      • #2381619
        PKCano
        Manager

        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.

         

        • #2381641
          Tchalms
          AskWoody Plus

          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.

          • #2381650
            PKCano
            Manager

            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.
      • #2381902
        Tchalms
        AskWoody Plus

        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!

         

    Viewing 2 reply threads

    Please follow the -Lounge Rules- no personal attacks, no swearing, no politics or religion.

    Reply To: Updating the SQL Server Native Client 11.0 on Windows 10 Pro

    You can use BBCodes to format your content.
    Your account can't use Advanced BBCodes, they will be stripped before saving.