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 the following table 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 PowerBuilder 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.
|
OLE DB object |
Required interfaces |
|---|---|
|
OLE DB Services |
IDataInitialize |
|
DataSource |
IDBInitialize IDBCreateSession IDBProperties IPersist |
|
Session |
ISessionProperties IOpenRowset |
|
Command |
ICommandText ICommandProperties |
|
MultipleResults |
IMultipleResults |
|
RowSet |
IRowset IAccessor IColumnsInfo IRowsetInfo |
|
Error |
IErrorInfo IErrorRecords |