Microsoft OLE DB Provider for DB2 works with Microsoft SQL Server to connect SQL applications and tools to IBM Db2 databases. 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 Provider for DB2 Version 6.0 from the command line using the MSI installer.
How to Install Microsoft OLE DB Provider for DB2 Version 6.0 Silently
Microsoft OLE DB Provider for DB2 Version 6.0 Silent Install (MSI) on 32-bit Systems
- Navigate to: https://www.microsoft.com/en-us/download/details.aspx?id=100917
- Click Download
- Select the DB2OLEDBv6_EN_x86.msi
- Click Next
- Download the DB2OLEDBv6_EN_x86.msi to a folder created at (C:\Downloads\x86)
- Navigate to: https://aka.ms/highdpimfc2013x86enu
- Download the vcredist_x86.exe to a folder created at (C:\Downloads\x86)
- Open an Elevated Command Prompt by Right-Clicking on Command Prompt and select Run as Administrator
- Navigate to the C:\Downloads\x86 folder
- Enter the following commands:
vcredist_x86.exe /install /quiet /norestart |
MsiExec.exe /i DB2OLEDBv6_EN_x86.msi /qn |
After a few moments you will find Microsoft OLE DB Provider for DB2 Version 6.0 entries in the Start Menu, Installation Directory and Programs and Features in the Control Panel.
| Software Title: | Microsoft OLE DB Provider for DB2 Version 6.0 |
| Vendor: | Microsoft Corporation |
| Architecture: | 32-bit |
| Installer Type: | MSI |
| Silent Install Switch (Step1) | vcredist_x86.exe /install /quiet /norestart |
| Silent Install Switch (Step2) | MsiExec.exe /i DB2OLEDBv6_EN_x86.msi /qn |
| Silent Uninstall Switch: | MsiExec.exe /x {EF786C44-FEA6-4E9A-8B1A-988D144F72D7} /qn |
| Repair Command: | MsiExec.exe /fa {EF786C44-FEA6-4E9A-8B1A-988D144F72D7} /qn |
| Download Link: | https://www.microsoft.com/en-us/download/details.aspx?id=100917 |
| PowerShell Script: | https://silentinstallhq.com/microsoft-ole-db-provider-for-db2-version-6-0-install-and-uninstall-powershell/ |
| Detection Script: | https://silentinstallhq.com/create-a-custom-detection-script-for-microsoft-ole-db-provider-for-db2-version-6-0-powershell/ |
Microsoft OLE DB Provider for DB2 Version 6.0 Silent Install (MSI) on 64-bit Systems
- Navigate to: https://www.microsoft.com/en-us/download/details.aspx?id=100917
- Click Download
- Select the DB2OLEDBv6_EN_x64.msi
- Click Next
- Download the DB2OLEDBv6_EN_x64.msi to a folder created at (C:\Downloads\x64)
- Navigate to: https://aka.ms/highdpimfc2013x86enu
- Download the vcredist_x86.exe to a folder created at (C:\Downloads\x64)
- Navigate to: https://aka.ms/highdpimfc2013x64enu
- Download the vcredist_x64.exe to a folder created at (C:\Downloads\x64)
- Open an Elevated Command Prompt by Right-Clicking on Command Prompt and select Run as Administrator
- Navigate to the C:\Downloads\x64 folder
- Enter the following commands:
vcredist_x86.exe /install /quiet /norestart |
vcredist_x64.exe /install /quiet /norestart |
MsiExec.exe /i DB2OLEDBv6_EN_x64.msi /qn |
After a few moments you will find Microsoft OLE DB Provider for DB2 Version 6.0 entries in the Start Menu, Installation Directory and Programs and Features in the Control Panel.
| Software Title: | Microsoft OLE DB Provider for DB2 Version 6.0 |
| Vendor: | Microsoft Corporation |
| Architecture: | 64-bit |
| Installer Type: | MSI |
| Silent Install Switch (Step1) | vcredist_x86.exe /install /quiet /norestart |
| Silent Install Switch (Step2) | vcredist_x64.exe /install /quiet /norestart |
| Silent Install Switch (Step3) | MsiExec.exe /i DB2OLEDBv6_EN_x64.msi /qn |
| Silent Uninstall Switch: | MsiExec.exe /x {EF786C44-FEA6-4E9A-8B1A-988D144F72D7} /qn |
| Repair Command: | MsiExec.exe /fa {EF786C44-FEA6-4E9A-8B1A-988D144F72D7} /qn |
| Download Link: | https://www.microsoft.com/en-us/download/details.aspx?id=100917 |
| PowerShell Script: | https://silentinstallhq.com/microsoft-ole-db-provider-for-db2-version-6-0-install-and-uninstall-powershell/ |
| Detection Script: | https://silentinstallhq.com/create-a-custom-detection-script-for-microsoft-ole-db-provider-for-db2-version-6-0-powershell/ |
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 a Microsoft OLE DB Provider for DB2 Version 6.0 Installation Log File
The Microsoft OLE DB Provider for DB2 Version 6.0 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 Provider for DB2 Version 6.0 Silent Install with Logging on 32-bit System
vcredist_x86.exe /install /quiet /norestart /log "%WINDIR%\Temp\VC2013x86-Install.log" |
MsiExec.exe /i DB2OLEDBv6_EN_x86.msi /qn /L*v "%WINDIR%\Temp\DB2OLEDBv6x86-Install.log" |
Microsoft OLE DB Provider for DB2 Version 6.0 Silent Install with Logging on 64-bit System
vcredist_x86.exe /install /quiet /norestart /log "%WINDIR%\Temp\VC2013x86-Install.log" |
vcredist_x64.exe /install /quiet /norestart /log "%WINDIR%\Temp\VC2013x64-Install.log" |
MsiExec.exe /i DB2OLEDBv6_EN_x64.msi /qn /L*v "%WINDIR%\Temp\DB2OLEDBv6x64-Install.log" |
How to Uninstall Microsoft OLE DB Provider for DB2 Version 6.0 Silently
Check out the following posts for a scripted solution:
| Microsoft OLE DB Provider for DB2 Version 6.0 Install and Uninstall (PowerShell) |
| Microsoft OLE DB Provider for DB2 Version 6.0 Silent Uninstall (PowerShell) |
- Open an Elevated Command Prompt by Right-Clicking on Command Prompt and select Run as Administrator
- Enter one of the following commands:
| Version | Microsoft OLE DB Provider for DB2 Version 6.0 Silent Uninstall String |
10.0.3047.0 (32-bit) | MsiExec.exe /x {EF786C44-FEA6-4E9A-8B1A-988D144F72D7} /qn |
10.0.3047.0 (64-bit) | MsiExec.exe /x {EF786C44-FEA6-4E9A-8B1A-988D144F72D7} /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.
