Provider=MSOLEDBSQL17;Data Source=myServer\instance;Initial Catalog=myDatabase;User ID=myUser;Password=myPass;
Or using integrated security:
Provider=MSOLEDBSQL17;Data Source=myServer;Initial Catalog=myDatabase;Integrated Security=SSPI;
PowerShell verification:
Get-ChildItem "HKLM:\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" | Where-Object $_.GetValue("DisplayName") -like "*OLE DB Driver*"
When configuring your application to use this driver, you must update your connection string to use the new Provider name. download microsoft ole db driver 17 for sql server -x64-
For Version 18 (Latest):
Provider=MSOLEDBSQL18;Server=YourServerName;Database=YourDatabase;Uid=YourUsername;Pwd=YourPassword;
For Version 17 (Legacy):
Provider=MSOLEDBSQL;Server=YourServerName;Database=YourDatabase;Uid=YourUsername;Pwd=YourPassword;