Microsoft OLEDB provider for DB2

This OLE DB Provider is provided by Microsoft.

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

Description

The Microsoft OLE DB Provider for DB2, distributed with Microsoft Host Integration Server, allows for SQL Server distributed queries to query data in DB2 databases.

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

Download

This OLE DB Provider, Microsoft OLEDB provider for DB2, can be downloaded here.

Connection Strings

The Microsoft OLEDB provider for DB2 provider can be used to connect to the following data sources by using the following connection string references:

IBM DB2

Providers

DB2 .NET Data Provider IBM DB2 Driver for ODBC and CLI .NET Framework Data Provider for OLE DB .NET Framework Data Provider for ODBC IBM OLE DB Provider for DB2

Articles

read all »
Formating Rules for Connection Strings Connection Strings Explained Store Connection String in Web.config Connection Pooling The Provider Keyword, ProgID, Versioning and COM CLSID Explained Store and read connection string in appsettings.json SQL Server Data Types Reference Network Protocol for SQL Server Connection All SQL Server SqlConnection Properties When to use the SQL Native Client