Installing Data Provider

This topic provides instructions to install the Data Provider.

Installing Data Provider

Supported Operating Systems

The Data Provider (32-bit x86 or 64-bit x64) will install on these Microsoft operating systems.

  • Windows Server 2008 R2 SP1

  • Windows 7 SP1

  • Windows Server 2008 SP2

Prerequisite Software

The Data Provider requires the following software products as installation prerequisites.

  • Microsoft SQL Server 2012 (Enterprise, Developer or Evaluation Edition) or Microsoft SQL Server 2008 R2 (Datacenter, Enterprise, Developer or Evaluation Edition)

  • Microsoft .NET Framework 4.0

  • Microsoft Visual C++ 2010 Redistributable Package (x86)

  • Microsoft Visual C++ 2010 Redistributable Package (x64)

    Note

    When installing on a 64-bit (x64) operating system, you must install both x86 and x64 of Visual Studio 2010 C++ packages.

Upgrade from Previous Version

Microsoft OLE DB Provider for DB2 V 4.0 does not upgrade previous releases. If you have the following previous versions installed, then you must remove them prior to installing the Microsoft OLE DB Provider for DB2 V 4.0.

  • Microsoft OLE DB Provider for DB2 V1.0

  • Microsoft OLE DB Provider for DB2 V1.0 with SP1

  • Microsoft OLE DB Provider for DB2 V2.0

  • Microsoft OLE DB Provider for DB2 V3.0

To Install the Product

There are two options for installing the Data Provider, including interactive installation and unattended installation. The following steps guide you through interactive installation.

  1. Go to the Microsoft Download Center.

  2. Download either the x86 (32-bit) or the x64 (64-bit) version of DB2OLEDB4_x64.msi installation program.

  3. Double-click the .msi file to start the Installation Wizard.

  4. Click Next to get started.

  5. On the License Agreement page, review the license terms, click the I accept the terms in the license agreement option, and then click Next.

  6. On the Registration Information page, enter your Name and Company, and then click Next.

  7. On the Feature Selection page, optionally click Browse to change the Folder name in which to install the product, optionally click Disk Cost to space required to install the product, and then click Next.

  8. On the Ready to Install the Program page, click Install.

  9. When prompted by Windows User Account Control, click Yes.

  10. On the Installing page, view the status of the installation process.

  11. On the Completion page, click Finish.

To install the product unattended

There are two options for installing the Service for DRDA, including interactive installation and unattended installation. The following steps guide you through unattended installation.

  1. On the Start menu, point to All Programs, point to Microsoft Visual Studio 2010, point to Visual Studio Tools, right click Visual Studio x64 Win64 Command Prompt (2010), and click Run as administrator. The User Account Control dialog will appear. Click Yes to continue.

  2. In the Visual Studio x64 Win64 Command Prompt (2010) window, locate the installation folder in which you downloaded the installation program, enter DB2OLEDB4_x64.msi /quiet.

  3. To verify the installation, locate the installed product in C:\Program Files\Microsoft OLE DB Provider for DB2.

    Note

    Optionally, to generate a log, add /l <log file name> to the command string. To verify the installation, enter notepad <log file name>, and then click Enter.

To repair the product installation

You can use Windows Programs and Features to launch the Program Maintenance to repair the installation.

  1. Click Control Panel, click Programs, and then click Programs and Features. The Uninstall or change a program dialog appears.

  2. In the Name list, double click Microsoft OLE DB Provider for DB2 Version 4.0. The Data Provider Installation Wizard appears.

  3. Click Next to get started.

  4. On the Program Maintenance dialog, click Repair.

  5. On the Ready to Repair the Program dialog, click Repair.

  6. When prompted by Windows User Account Control, click Yes.

  7. On the Completion page, click Finish.

To uninstall the product

You can use Windows Programs and Features to remove the product.

  1. Click Control Panel, click Programs, and then click Programs and Features. The Uninstall or change a program dialog appears.

  2. In the Name list, double click Microsoft OLE DB Provider for DB2 Version 4.0. The Data Provider Installation Wizard appears.

  3. Click Next to get started.

  4. On the Program Maintenance dialog, click Remove.

  5. On the Remove the Program dialog, click Remove.

  6. When prompted by Windows User Account Control, click Yes.

  7. On the Completion page, click Finish.

To uninstall the product unattended

You can use an unattended command to uninstall the product.

  1. On the Start menu, point to All Programs, point to Microsoft Visual Studio 2010, point to Visual Studio Tools, right click Visual Studio x64 Win64 Command Prompt (2010), and click Run as administrator. The User Account Control dialog will appear. Click Yes to continue.

  2. In the Visual Studio x64 Win64 Command Prompt (2010) window, locate the installation folder in which you downloaded the installation program, enter DB2OLEDB4_x64.msi /uninstall /quiet, and then click Enter.

  3. To verify the removal, locate the installed product in C:\Program Files\ Microsoft OLE DB Provider for DB2.

    Note

    Optionally, to generate a log, add /l <log file name> to the command string. To verify the installation, enter notepad <log file name>, and then click Enter.