Microsoft OLE DB Provider for DB2 V3.0 is available

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:

http://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:

http://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:

http://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