This project has moved. For the latest updates, please go here.

Previous Install Java DBC Driver Manual Install Install SQL Cache Manager Next

Install OLE Provider for DB2

FineBuild can install and configure the Microsoft OLE Provider for DB2 as part of the SQL Server install process.
If you do not want to include the OLE Provider for DB2 in your FineBuild install, then do not download it.

DB2 OLE Provider is written by Microsoft. It was chosen to be included in FineBuild because it allows SQL Server to access DB2 databases.

If you intend to make regular use of DB2 connectivity from SQL Server, it is suggested that you purchase the IBM DB2 Connect product, as this will provide greater integration with DB2 facilities.

OLE Provider for DB2 V4 home page SQL 2012 http://msdn.microsoft.com/library/hh598132(SQL.10).aspx
OLE Provider for DB2 V4 download SQL 2012 X86: http://go.microsoft.com/fwlink/?LinkID=239681
X64: http://go.microsoft.com/fwlink/?LinkID=241453
OLE Provider for DB2 V3 home page SQL 2008 R2 and below http://msdn.microsoft.com/en-us/library/hh335121(v=sql.105).aspx
OLE Provider for DB2 V3 download SQL 2008 R2 and below http://go.microsoft.com/fwlink/?LinkID=188403

OLE Provider for DB2 V3 can only be used with SQL Server 2008 R2 and below. OLE Provider for DB2 V4 can only be used with SQL Server 2012 and above.

FineBuild OLE Provider for DB2 Install

Automated silent installation of OLE Provider for DB2 is performed by Process Id 4SC and is controlled by the parameters below:

Install Parameter Build SQL2005 SQL2008 SQL2008R2 SQL2012 SQL2014
SetupDB2OLE FULL Yes Yes Yes Yes Yes
SetupDB2OLE WORKSTATION Yes Yes Yes Yes Yes
SetupDB2OLE CLIENT N/A N/A N/A N/A N/A

In order to maintain compatibility with older versions of SQL FineBuild, the parameter InstDB2OLE can also be used.

FineBuild also uses the following parameters to help install Microsoft OLE Provider for DB2:
Parameter SQL Version Default Value Description
DB2exe SQL 2008 R2 or below DB2OLEDB.exe Name of Microsoft OLE Provider for DB2 install file
DB2OLEX86msi SQL 2012 or above 32-bit DB2OLEDBV4x86.msi Name of Microsoft OLE Provider for DB2 install file
DB2OLEX64msi SQL 2012 or above 64-bit DB2OLEDBV4x64.msi Name of Microsoft OLE Provider for DB2 install file

The Microsoft OLE Provider for DB2 can only be installed on Developer, Enterprise, Evaluation or Data Centre Editions, and cannot be installed on Standard Edition or below.

FineBuild will install OLE Provider for DB2 V3 for SQL 2008 R2 and below, and will install OLE Provider for DB2 V4 for SQL 2012.

The FineBuild install for OLE Provider for DB2 includes the following:
  • Install the OLE Provider for DB2
  • Setup OLE Provider for DB2 Menu Item

Manual OLE Provider for DB2 Install

The following steps show what you would have to do to install OLE Provider for DB2 manually. FineBuild does all of this work for you automatically.

Use the correct process for the version of SQL Serve ryou are installing:
SQL Version Install Process
SQL 2012 or above Install OLE Provider for DB2 V4
SQL 2008 R2 and below Install OLE Provider for DB2 V3

Install OLE Provider for DB2 V4

OLE Provider for DB2 V4 can be installed for SQL 2012.

1) Navigate to the Additional Components folder and double-click on the required file:
System File
32-bit DB2OLEDBV4x86.msi
64-bit DB2OLEDBV4x64.msi

2) Click on the relevant buttons to complete the installation

3) Move the menu for Microsoft OLE Provider for DB2 V4 to the Microsoft SQL Server menu structure, so that all tools for SQL Server are found in one place.
Top

Install OLE Provider for DB2 V3

OLE Provider for DB2 V3 can be installed for SQL 2008 R2 or below.

1) Navigate to the Additional Components folder and double-click on DB2OLEDB.exe.
DB2OLE Explorer.png
2) The Winzip Self-Extractor window is displayed. Set the Unzip folder to T:\Temp\DB2OLDEB then click Unzip.
DB2OLE Unzip.png
All files are unzipped. Click OK to continue, then click Close on the Winzip Self-Extractor window.
DB2OLE Extract.png
3) Navigate to T:\Temp\DB2OLEDB and double-click on Setup.exe.
DB2OLE Setup.png
4) The Start window is displayed. Click on Install to continue.
DB2OLE Start.png
5) Enter the Customer information. Click Next to continue.
DB2OLE Customer.png
6) Accept the License Agreement. Click Next to continue.
DB2OLE License.png
7) Accept the Component Installation. Click Next to continue.
DB2OLE Component.png
8) Setup is ready to install. Click Install to continue.
DB2OLE Summary.png
9) The installation has completed successfully. Click Finish to end.
DB2OLE Complete.png

Setup OLE Provider for DB2 Menu Item

Move the menu for Microsoft OLE Provider for DB2 to the Microsoft SQL Server menu structure, so that all tools for SQL Server are found in one place.

1) Navigate to Start -> All programs. Right-click on Microsoft OLE DB Provider for DB2 and select Explore.
DB2OLE Menu Explorer.png
2) Drag the Microsoft OLE Provider for DB2 menu entry to the Microsoft SQL Server 20xx\Configuration Tools folder.
DB2OLE Menu Drag.png
Copyright © 2011 - 2014 Edward Vassie. License and Acknowledgements
Previous Install Java DBC Driver Top Install SQL Cache Manager Next

Last edited Oct 23, 2014 at 12:40 PM by EdVassie, version 22