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

Comments (10)

  1. Vitaly says:

    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?

  2. Stephen Jackson says:

    No, the OLE DB Provider for DB2 does not support the UniVerse and UniData platforms.

  3. eXavier3 says:

    Why I need SQL Server for DB2 provider?

  4. Stephen Jackson says:

    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.

  5. Adam J. says:

    Does this support SQL Server 2005 64-bit?

  6. robert says:

    does anyone have any statistics on the "fastload" available with this version?

  7. BobCinGRR says:

    Requires Enterprise or Datacenter

  8. BobCinGRR says:

    Requires Enterprise or Datacenter

  9. Dr. Blez says:

    when i execute EXEC ('CALL SOME.PROC(?)', @Param) AT DB2LINK i receive message "A SQL error has occurred.  Please consult the documentation for your specific DB2 version for a description of the associated Native Error and SQL State. SQLSTATE: 42612, SQLCODE: -84", but EXEC ('CALL SOME.PROC_WO_PARAMS') AT DB2LINK work correctly.

  10. Kiran Mahale says:

    Do you have upgrade for sql server 2012 64 bit?