免互動安裝Microsoft OLE DB Driver for SQL Server、解除安裝,以及在部署工具中偵測安裝狀態所用的指令。只列出確定可用的指令:來自資訊清單,或是安裝程式技術的官方預設參數。
相關教學: 靜默安裝參數總整理:MSI、NSIS、Inno Setup · 用登錄檔或PowerShell解除安裝程式
使用winget
PowerShell
winget install --id Microsoft.SQLServer.OLEDBDriver -e --silent --accept-package-agreements --accept-source-agreementswinget upgrade --id Microsoft.SQLServer.OLEDBDriver -e --silentwinget uninstall --id Microsoft.SQLServer.OLEDBDriver -e --silent依安裝檔
64位元 · MSI · 所有使用者 · de-DE
靜默安裝
msiexec /i msoledbsql.msi /qn /norestart /qn IACCEPTMSOLEDBSQLLICENSETERMS=YES寫入記錄檔
msiexec /i msoledbsql.msi /qn /norestart /qn IACCEPTMSOLEDBSQLLICENSETERMS=YES /l*v "%TEMP%\microsoft-ole-db-driver-for-sql-server-install.log"解除安裝
msiexec /x {D18429DE-40A6-4F7E-9B18-F11A00BA9A90} /qn /norestart- MSI產品代碼
- {D18429DE-40A6-4F7E-9B18-F11A00BA9A90}
- 解除安裝登錄機碼
- HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{D18429DE-40A6-4F7E-9B18-F11A00BA9A90}
- UpgradeCode
- {B1F32E34-48E0-426C-8B0F-9DB732A4C975}
64位元 · MSI · 所有使用者 · en-US
靜默安裝
msiexec /i msoledbsql.msi /qn /norestart /qn IACCEPTMSOLEDBSQLLICENSETERMS=YES寫入記錄檔
msiexec /i msoledbsql.msi /qn /norestart /qn IACCEPTMSOLEDBSQLLICENSETERMS=YES /l*v "%TEMP%\microsoft-ole-db-driver-for-sql-server-install.log"解除安裝
msiexec /x {B8F87A96-2998-43A5-93BC-379FF776784F} /qn /norestart- MSI產品代碼
- {B8F87A96-2998-43A5-93BC-379FF776784F}
- 解除安裝登錄機碼
- HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{B8F87A96-2998-43A5-93BC-379FF776784F}
- UpgradeCode
- {B1F32E34-48E0-426C-8B0F-9DB732A4C975}
64位元 · MSI · 所有使用者 · it-IT
靜默安裝
msiexec /i msoledbsql.msi /qn /norestart /qn IACCEPTMSOLEDBSQLLICENSETERMS=YES寫入記錄檔
msiexec /i msoledbsql.msi /qn /norestart /qn IACCEPTMSOLEDBSQLLICENSETERMS=YES /l*v "%TEMP%\microsoft-ole-db-driver-for-sql-server-install.log"解除安裝
msiexec /x {031C8E7C-114A-4AF1-A3A2-B8680671D2AE} /qn /norestart- MSI產品代碼
- {031C8E7C-114A-4AF1-A3A2-B8680671D2AE}
- 解除安裝登錄機碼
- HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{031C8E7C-114A-4AF1-A3A2-B8680671D2AE}
- UpgradeCode
- {B1F32E34-48E0-426C-8B0F-9DB732A4C975}
PowerShell:下載、驗證、安裝
下載官方檔案,驗證SHA256後靜默安裝。
install-microsoft-ole-db-driver-for-sql-server.ps1
$url = 'https://download.microsoft.com/download/6afc73cd-aad7-4bab-876a-ab0dcc8a9001/amd64/1031/msoledbsql.msi'
$sha256 = 'B300A2735E306ADB3E6606E4D210B22CB36400E9F431F8463E49CA089A70F464'
$file = Join-Path $env:TEMP 'msoledbsql.msi'
Invoke-WebRequest -Uri $url -OutFile $file -UseBasicParsing
if ((Get-FileHash $file -Algorithm SHA256).Hash -ne $sha256) { throw 'SHA256 mismatch' }
Start-Process msiexec.exe -ArgumentList '/i', ('"{0}"' -f $file), '/qn', '/norestart', '/qn IACCEPTMSOLEDBSQLLICENSETERMS=YES' -Wait install-microsoft-ole-db-driver-for-sql-server.ps1
$url = 'https://download.microsoft.com/download/bbb0d870-7a04-44d9-af17-af28575a0ed8/amd64/1033/msoledbsql.msi'
$sha256 = 'C1D5BD79C316588FB08C852ACF76628AB662426E763B68AEF4CFA25FA1DD7BEB'
$file = Join-Path $env:TEMP 'msoledbsql.msi'
Invoke-WebRequest -Uri $url -OutFile $file -UseBasicParsing
if ((Get-FileHash $file -Algorithm SHA256).Hash -ne $sha256) { throw 'SHA256 mismatch' }
Start-Process msiexec.exe -ArgumentList '/i', ('"{0}"' -f $file), '/qn', '/norestart', '/qn IACCEPTMSOLEDBSQLLICENSETERMS=YES' -Wait install-microsoft-ole-db-driver-for-sql-server.ps1
$url = 'https://download.microsoft.com/download/1462d639-ae55-42d1-9f6b-c35235018be6/amd64/1040/msoledbsql.msi'
$sha256 = 'AEB50937D45A0D22EB6B200F95CFB9B1F28D72502CCF4B2B4FBF0703E64D191D'
$file = Join-Path $env:TEMP 'msoledbsql.msi'
Invoke-WebRequest -Uri $url -OutFile $file -UseBasicParsing
if ((Get-FileHash $file -Algorithm SHA256).Hash -ne $sha256) { throw 'SHA256 mismatch' }
Start-Process msiexec.exe -ArgumentList '/i', ('"{0}"' -f $file), '/qn', '/norestart', '/qn IACCEPTMSOLEDBSQLLICENSETERMS=YES' -Wait