OLE DB data providers – PB Docs 2021

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
(only required if DBTYPE_HCHAPTER is supported)

Error

IErrorInfo

IErrorRecords


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x