The following table shows the OLE DB providers for which you can create OLE DB table functions. The table also shows the versions of DB2® that support each OLE DB provider.
| Supported | OLE DB Provider | Description |
|---|---|---|
| DB2 V9.1, V8.2 | ADsDSOOBJECT | OLE DB Provider for Microsoft Directory Services |
| DB2 V8.2 | ASAProv.80 | Sybase Adaptive Server Anywhere Provider 8.0 |
| DB2 V8.2 | DTSPackageDSO | Microsoft OLE Db Provider for DTS Packages |
| DB2 V9.1 | MediaCatalogDB OLE DB Provider | MediaCatalogDB OLE DB Provider |
| DB2 V9.1 | MediaCatalogMergedDB OLE DB Provider | MediaCatalogMergedDB OLE DB Provider |
| DB2 V9.1 | MediaCatalogWebdDB OLE DB Provider | MediaCatalogWebdDB OLE DB Provider |
| DB2 V8.2 | Microsoft.ISAM.OLEDB.1.1 | Microsoft ISAM 1.1 OLE DB Provider |
| DB2 V9.1, V8.2 | Microsoft.Jet.OLEDB.4.0 | Microsoft Jet 4:0 OLE DB Provider |
| DB2 V9.1, V8.2 | MSDAIPP.DSO | Microsoft OLE DB Provider for Internet Publishing |
| DB2 V9.1, V8.2 | MSDAORA | Microsoft OLE DB Provider for Oracle |
| DB2 V9.1, V8.2 | MSDAOSP | Microsoft OLE DB Simple Provider |
| DB2 V9.1, V8.2 | MSDASQL | Microsoft OLE DB Provider for ODBC Drivers |
| DB2 V9.1, V8.2 | MSDataShape | MSDataShape |
| DB2 V9.1, V8.2 | MSDMine | Microsoft OLE DB Provider For Data Mining Services |
| DB2 V9.1, V8.2 | MSIDXS | Microsoft OLE DB Provider for Indexing Services |
| DB2 V8.2 | MSOLAP | Microsoft OLE DB Provider for Analysis Services 9.0 |
| DB2 V9.1, V8.2 | MSOLAP | Microsoft OLE DB Provider for OLAP Services 8.0 |
| DB2 V8.2 | MSOLAP | Microsoft OLE DB Provider for OLAP Services |
| DB2 V9.1, V8.2 | SQLNCL1 | SQL Native Client |
| DB2 V9.1, V8.2 | SQLOLEDB | Microsoft OLE DB Provider for SQL Server |
| DB2 V8.2 | SQLReplication.OLEDB | SQL Server Replication OLE DB Provider for DTS |
| DB2 V8.2 | SQLXMLOLEDB | SQLXMLOLEDB |
| DB2 V8.2 | SQLXMLOLEDB.4.0 | SQLXMLOLEDB.4.0 |
| DB2 V8.2 | VSEE Versioning Enlistment Manager Proxy Data Source | VSEE Versioning Enlistment Manager Proxy Data Source |
Creating OLE DB Table Functions | IBM OLE DB Table Function Designer