Where to download the old SQL ODBC driver version 10 (not the Native Client) [closed]

Question

We have a legacy application that fails to connect to SQL Server on certain computer (we have activated TLS, and that computer now raises an SSL error).

The problem is that the application is hard-coded to connect through the driver named "SQL Server", so my question is where can I download the latest installer of that old ODBC Driver ?.

I'm looking for the latest installer, because on my computer I have a more modern version of that driver and it runs correctly the legacy application that raises this error.

On the Microsoft site I've only found the more modern ODBC drivers for SQL Server (version 11 and upwards).

Bleareyed

According to Compatibility of ODBC driver SQLSRV32.dll with SQL Server versions, the driver comes with windows. – Submergible

Thanks @Larnu. There is no installer available independently ?, That user runs on a terminal server 2016 that I wouldn't like to mess too much. – Bleareyed

@MarcGuillot, correct, the drivers included with Windows are aligned with the OS version and cannot be installed separately. Not sure about ODBC but the SQLOLEDB driver included with Windows Server 2019 does support TLS 1.2 (see this thread). – Backstitch

Thanks @DanGuzman, looks like we will need to have that legacy application updated (its connection string is hardcoded, so as of now it won't use the SQLOLEDB driver). – Bleareyed

Answer 1

TLDR: You need to update that PC to a newer version of Windows 10. According to Microsoft, the "SQL Server" ODBC driver included in Windows 10 Build 17763.1554 and later supports TLS 1.2.

---

Details: The legacy MDAC "SQL Server" driver comes bundled with Windows.

Note that the build numbers of the "SQL Server" ODBC driver in your screen shots exactly match the following Windows 10 build numbers:

• 10.00.14393: Windows 10 1607 (Redstone 1)
• 10.00.19041: Windows 10 20H1

This does not mean that your PC uses that ancient version of Windows 10; it seems to be the lastest version in which that ODBC driver was updated (I use Windows 10 21H2 and the SQL Server ODBC driver still shows up as 10.00.19041).

Ningsia

Yes, that user runs on a Windows quite old (it's a Terminal Server 2016). I didn't realized that the driver was bundled with Windows. Looks like that we will need to find the original programmer so he updates that application to use a modern ODBC driver for SQL Server. – Bleareyed

Answer 2

Found this location. Maybe you can use this?

SQL Server Native Client 10.0 ODBC Driver

Update: According to that page: The driver is included in the "Microsoft SQL Server 2008 Feature Pack".

This is at: Microsoft SQL Server 2008 Service Pack 4 Feature Pack

and the link to the service pack: SQL Server 2008 Service Pack 4

Clementinaclementine

The "SQL Server Native Client" is a distinct driver with a distinct name. An application specifically asking for "SQL Server" will not get this driver. It's a bit unfortunate that there are now no less than three (at least) different "branches" of Microsoft-supplied ODBC drivers for SQL Server all vaguely containing "SQL Server", but there we are. – Hermeneutics

The links in that article, to the downloads, appear to also be broken. – Submergible

Answer 3

I had the same issue. The solution: Another computer with a working copy of this driver, have them open regedit32.exe and export [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\SQL Server] and [HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBCINST.INI\SQL Server]. On the machine that needs the driver, from administrative tools right click on Registry Editor and run as administrator. File import and import the 2 files exported above. Worked for me! (after days of looking). Credit goes to my boss.

Deprave