Microsoft OLE DB Provider for DB2 V3.0 is available

  • Article

The latest version of the standalone OLE DB Provider for DB2 is now available as part of the Microsoft SQL Server 2008 R2 Feature Pack at the following link:

https://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=ceb4346f-657f-4d28-83f5-aae0c5c83d52

If you want to directly download the Microsoft OLE DB Provider for DB2, you can use the following link:

https://go.microsoft.com/fwlink/?LinkID=188403&clcid=0x409

This version follows the Microsoft OLE DB Provider for DB2 2.0 that is discussed on the following blog post that I posted when that version was released:

https://blogs.msdn.com/b/sjackson/archive/2008/09/03/microsoft-ole-db-provider-for-db2-2-0-is-now-available.aspx

Here are some details from the Installation Guide.htm and Readme.htm files included with the download:

Installation Prerequisites

OLE DB Provider for DB2 V3.0 requires one of the following software products as installation prerequisites.

  • Microsoft SQL Server 2008 R2
  • Microsoft SQL Server 2008
  • Microsoft SQL Server 2005 with SP3

Features
The Microsoft OLE DB Provider for DB2 V3.0 supports the following features.

  • Installation using an interactive and scriptable setup program
  • Help through on-line user documentation
  • Assistance in creating, modifying and storing data source definitions using Data Provider-specific Data Access Tool and Data Source Wizard, or common OLE DB Data Links
  • Access to remote DB2 servers across TCP/IP network connections
  • Execution of dynamic SQL commands (DDL and DML), including CALL statements for stored procedures (with multiple result sets)
  • Trace Utility

Improvements in V3.0
The following are product improvements in OLE DB Provider for DB2 V3.0.

  • SQL Server 2008 R2 database software
  • Windows Server 2008 R2 operating system
  • Windows 7 operating system
  • Upgrade OLE DB Provider for DB2 V1.0, V1.0 with SP1, or V2.0
  • Internet Protocol v6 networking
  • Secure Sockets Layer encryption
  • DB2 Data encryption
  • Enterprise Single Sign-On authentication
  • OpenRowset using FastLoad
  • Connection Cancel
  • Command Cancel
  • Data Source Wizard all properties
  • DB2 for z/OS BIGINT data types
  • DB2 for z/OS V9 database server
  • DB2 for i5/OS V6R1 database server
  • DB2 Universal Database V9.5 and V9.7 database servers

Supported IBM DB2 Servers
The Microsoft OLE DB Provider for DB2 V3.0 supports the following IBM DB2 servers.

  • IBM DB2 for z/OS V8.1 and DB2 for z/OS V9.1
  • IBM DB2 for i5/OS V5R4 and DB2 for i5/OS V6R1
  • IBM DB2 UDB for Windows, AIX, HP-UX, Solaris, Linux V9.1, V9.5, V9.7