Download !link! Microsoft Ole Db Driver 17 For Sql Server -x64- Online

Guide to Downloading and Installing Microsoft OLE DB Driver for SQL Server (x64)

The x64 driver does not install on 32-bit-only systems, but runs in WOW64 on 64-bit Windows.
After installation, connection strings use Provider=MSOLEDBSQL19 (for v18) or Provider=MSOLEDBSQL (for v17). Check the exact provider name via ODBC Data Source Administrator.
Restarting services (e.g., IIS) may be required for the driver to be recognized by running applications.

installed. You’ll need both the x86 and x64 versions of the redistributable to properly install the x64 OLE DB driver. Connection String download microsoft ole db driver 17 for sql server -x64-

Method 1: Using ODBC Data Source Administrator (64-bit)

Open Run (Win + R), type odbcad32.exe (note: this opens the 64-bit version; for 32-bit, you would use odbcad32.exe from SysWOW64, but you installed x64).
Go to the Drivers tab.
Scroll down to find "Microsoft OLE DB Driver for SQL Server" with version 17.xx.xx.xx.
The “File” column should point to a path like C:\Program Files\Microsoft OLE DB Driver for SQL Server\msoledbsql.dll (the Program Files directory confirms it's x64).

$connString = "Provider=MSOLEDBSQL;Data Source=your_server;Initial Catalog=master;Integrated Security=SSPI;"
$conn = New-Object System.Data.OleDb.OleDbConnection($connString)
try 
    $conn.Open()
    Write-Host "Connection successful" -ForegroundColor Green
    $conn.Close()
 catch 
    Write-Host "Error: $_" -ForegroundColor Red