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:

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

Comments

• Anonymous
  June 11, 2010
  Is IBM's U2 database family - i.e. UniVerse and UniData systems - supported by this provider? If so, where can one find documentation on setting up the connections to these systems?

• Anonymous
  June 29, 2010
  No, the OLE DB Provider for DB2 does not support the UniVerse and UniData platforms.

• Anonymous
  July 12, 2010
  Why I need SQL Server for DB2 provider?

• Anonymous
  July 13, 2010
  You don't need SQL Server in general to use a DB2 Provider. It is just that this particular version is offered as an additional free add-on to SQL Server for those customers that want to integrate SQL Server with IBM DB2.

• Anonymous
  August 10, 2010
  Does this support SQL Server 2005 64-bit?

• Anonymous
  September 29, 2010
  does anyone have any statistics on the "fastload" available with this version?

• Anonymous
  October 18, 2010
  Requires Enterprise or Datacenter

• Anonymous
  October 18, 2010
  Requires Enterprise or Datacenter

• Anonymous
  November 21, 2010
  The comment has been removed

• Anonymous
  April 15, 2013
  Do you have upgrade for sql server 2012 64 bit?