OLE DB data providers

When you use the .NET Framework data provider for OLE DB, you connect to a database through an OLE DB data provider, such as Microsoft’s SQLOLEDB or MSDAORA or a data provider from another vendor.

The .NET Framework Data Provider for OLE DB does not work with the MSDASQL provider for ODBC, and it does not support OLE DB version 2.5 interfaces.

You can use any OLE DB data provider that supports the OLE DB interfaces listed in Table 4-2 with the OLE DB .NET Framework data provider. For more information about supported providers, see the topic on .NET Framework data providers in the Microsoft .NET Framework Developer’s Guide.

The DataWindow Designer ADO.NET interface supports connection to SQL Anywhere, Adaptive Server Enterprise, Microsoft SQL Server, Oracle, Informix, and Microsoft Access with the OLE DB .NET Framework data provider.

After you install the data provider, you might need to define a data source for it.

**Table 4-2: Required interface support for OLE DB data providers**
OLE DB object	Required interfaces
OLE DB Services	IDataInitialize
DataSource	IDBInitializeIDBCreateSessionIDBPropertiesIPersist
Session	ISessionPropertiesIOpenRowset
Command	ICommandTextICommandProperties
MultipleResults	IMultipleResults
RowSet	IRowsetIAccessorIColumnsInfoIRowsetInfo (only required if DBTYPE_HCHAPTER is supported)
Error	IErrorInfoIErrorRecords