To confirm successful installation, check the following registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSOLEDBSQL\CurrentVersion
When utilizing this driver in connection strings, the provider name has changed from the legacy SQLOLEDB to the updated string:
Provider=msoledbsql;Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password; Use code with caution.
✅