A recent update on our database server to disable TLS1.0 and 1.1 has forced me down the route of investigating which provider I can use to connect a legacy VB app to a SQL Server 2016 database.
I understand the SQLOLEDB driver isn't being maintained anymore and the recommendation is to use MSOLEDBSQL. However updating connection strings to use MSOLEDBSQL isn't really going to be viable for me.
For most users the client app is running on Windows 10 enterprise build which actually contains an updated version of SQLOLEDB which works with TL1.2; so no problems here.
But, some of users are running the client app on Windows server 2016 which contains an older version of SQLOLEDB (sqloledb.dll v10.0.14393.6167) which appears doesn't support TLS1.2
Question is: Does anyone where I can actually install the latest version of SQLOLEDB from? Searching on Microsoft always diverts to providing MSOLEDBSQL for download (and not SQLOLEDB)! Could we simply copy the newer sqloledb.dll to the affected servers?
Many thanks!