Microsoft OLE DB Driver for SQL Server Silent Install (How-To Guide)


The Microsoft OLE DB Driver for SQL Server is a stand-alone data access application programming interface (API), used for OLE DB. This article will serve as an informative guide and give you a clear understanding of how to perform a silent installation of the Microsoft OLE DB Driver for SQL Server from the command line using the MSI installer.

How to Install Microsoft OLE DB Driver for SQL Server Silently

Microsoft OLE DB Driver for SQL Server Silent Install (MSI) on 32-bit Systems

  1. Navigate to: https://docs.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver15
  2. Select Download Microsoft OLE DB Driver for SQL Server (x86)
  3. Download the msoledbsql.msi to a folder created at (C:\Downloads)
  4. Open an Elevated Command Prompt by Right-Clicking on Command Prompt and select Run as Administrator
  5. Navigate to the C:\Downloads folder
  6. Enter the following command: MsiExec.exe /i msoledbsql.msi IACCEPTMSOLEDBSQLLICENSETERMS=YES /qn
  7. Press Enter

After a few moments you will find Microsoft OLE DB Driver for SQL Server entries in the Installation Directory and Programs and Features in the Control Panel.

Software Title:Microsoft OLE DB Driver for SQL Server
Vendor:Microsoft Corporation
Version:18.5.0.0
Architecture:32-bit
Installer Type:MSI
Silent Install Switch:MsiExec.exe /i msoledbsql.msi IACCEPTMSOLEDBSQLLICENSETERMS=YES /qn
Silent Uninstall Switch:MsiExec.exe /x {20540984-F00D-4E5F-BE55-577BD83770A6} /qn
Repair Command:MsiExec.exe /fa {20540984-F00D-4E5F-BE55-577BD83770A6} /qn
Download Link:https://docs.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver15

Microsoft OLE DB Driver for SQL Server Silent Install (MSI) on 64-bit Systems

  1. Navigate to: https://docs.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver15
  2. Select Download Microsoft OLE DB Driver for SQL Server (x64)
  3. Download the msoledbsql.msi to a folder created at (C:\Downloads)
  4. Open an Elevated Command Prompt by Right-Clicking on Command Prompt and select Run as Administrator
  5. Navigate to the C:\Downloads folder
  6. Enter the following command: MsiExec.exe /i msoledbsql.msi IACCEPTMSOLEDBSQLLICENSETERMS=YES /qn
  7. Press Enter

After a few moments you will find Microsoft OLE DB Driver for SQL Server entries in the Installation Directory and Programs and Features in the Control Panel.

Software Title:Microsoft OLE DB Driver for SQL Server
Vendor:Microsoft Corporation
Version:18.5.0.0
Architecture:64-bit
Installer Type:MSI
Silent Install Switch:MsiExec.exe /i msoledbsql.msi IACCEPTMSOLEDBSQLLICENSETERMS=YES /qn
Silent Uninstall Switch:MsiExec.exe /x {9D6F8754-28E9-4940-B319-3FC8588CF18F} /qn
Repair Command:MsiExec.exe /fa {9D6F8754-28E9-4940-B319-3FC8588CF18F} /qn
Download Link:https://docs.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver15

The information above provides a quick overview of the software title, vendor, silent install, and silent uninstall switches. The download links provided take you directly to the vendors website. Continue reading if you are interested in additional details and configurations.


Additional Configurations

Create an Installation Log File

The Microsoft OLE DB Driver for SQL Server installer offers the option to generate a log file during installation to assist with troubleshooting should any problems arise. You can use the following commands to create a verbose log file with details about the installation.

Microsoft OLE DB Driver for SQL Server Silent Install with Logging (MSI)

MsiExec.exe /i msoledbsql.msi IACCEPTMSOLEDBSQLLICENSETERMS=YES /qn /L*v "%WINDIR%\Temp\MSOLEDBSQL-Install.log"

How to Uninstall Microsoft OLE DB Driver for SQL Server Silently

  1. Open an Elevated Command Prompt by Right-Clicking on Command Prompt and select Run as Administrator
  2. Enter one of the following commands:
VersionOLE DB Driver for SQL Server Silent Uninstall String
18.5.0 (32-bit)MsiExec.exe /x {20540984-F00D-4E5F-BE55-577BD83770A6} /qn
18.5.0 (64-bit)MsiExec.exe /x {9D6F8754-28E9-4940-B319-3FC8588CF18F} /qn
18.4.0 (32-bit)MsiExec.exe /x {5EFA6EA2-0398-401B-82C1-5BFD203BAF89} /qn
18.4.0 (64-bit)MsiExec.exe /x {03B147EA-8A90-4E8C-A5B7-6879A421636C} /qn
18.3.0 (32-bit)MsiExec.exe /x {8939E45F-1102-4256-9602-0796ECE27FB9} /qn
18.3.0 (64-bit)MsiExec.exe /x {74A97B61-DE37-40DF-9E00-B302E5D3C4CE} /qn
18.2.3 (32-bit)MsiExec.exe /x {7E106027-A708-4E47-B138-8BB9BAFDB530} /qn
18.2.3 (64-bit)MsiExec.exe /x {9AA0AFFA-EDB6-4B66-9FD7-BBC828D88B47} /qn
18.2.2 (32-bit)MsiExec.exe /x {FC71FF10-7C06-48F1-9D70-3660F32E3AE8} /qn
18.2.2 (64-bit)MsiExec.exe /x {A395278F-3211-4F28-ADF9-D6028F93AB70} /qn
18.2.1 (32-bit)MsiExec.exe /x {251CC497-3CB2-4C2C-9324-5DE8DA29DE25} /qn
18.2.1 (64-bit)MsiExec.exe /x {EE6D1BC2-277F-4841-8FC9-DE132F856BB8} /qn
18.1.0 (32-bit)MsiExec.exe /x {04211FE6-5B96-464D-986C-243FAABC06AB} /qn
18.1.0 (64-bit)MsiExec.exe /x {21140C60-9666-4C11-B694-FD63EE6A6308} /qn
18.0.2 (32-bit)MsiExec.exe /x {EE5630F1-4FD7-48FB-9E4A-C4132FE0E37C} /qn
18.0.2 (64-bit)MsiExec.exe /x {23438EF7-40CA-483B-A22D-756407B7A503} /qn

Always make sure to test everything in a development environment prior to implementing anything into production. The information in this article is provided “As Is” without warranty of any kind.

Recent Posts