Recently, Microsoft let us know that the ODBC drive needs to be updated for any webservers connecting to an SQL server.
- Why the new update
The biggest issue with not updating the driver is that the older driver tries to use TLS 1.0. This will cause conflicts with your environment that is now on TLS 1.2
- What is ODBC?
ODBC consists of four components, working together to enable functions. ODBC allows programs to use SQL requests that access databases without knowing the proprietary interfaces to the databases. ODBC handles the SQL request and converts it into a request each database system understands.
The four different components of ODBC are:
- Application: Processes and calls the ODBC functions and submits the SQL statements;
- Driver manager: Loads drivers for each application;
- Driver: Handles ODBC function calls, and then submits each SQL request to a data source; and
- Data source: The data being accessed and its database management system (DBMS) OS.
- How to check your driver:
- Open a command prompt or PowerShell
- Enter: odbcad32.exe
- You should see an ODBC driver installed
- Where to download it from:
Use this link to download: https://www.microsoft.com/en-us/download/details.aspx?id=50402
- Why is it named Microsoft® SQL Server® 2012 Native Client
I to ask them this. Apparently, it came out in 2012 and they just kept the name. However, it has been updated over the years and is smart enough to install the correct year ODBC driver for your server.