IBM OLE DB Provider for DB2

This OLE DB Provider is provided by IBM.

Include "Provider=IBMDADB2" in the connection string to use this provider.


The IBM OLE DB Provider for DB2 offers the following features:
Support level 0 of the OLE DB provider specification, including some additional level 1 interfaces.
A free threaded provider implementation, which enables the application to create components in one thread and use those components in any other thread.
An error lookup service that returns DB2 error messages.

  The provider is shipped with IBM DB2 UDB v7 or above.

More info about this provider can be found at the IBM product page.


There is no 'IBM OLE DB Provider for DB2' installation package to download. (if you know about an installation package URL you can contribute to the community by submitting the info to us through this message form)

Connection Strings

The IBM OLE DB Provider for DB2 provider can be used to connect to the following data sources by using the following connection string references: