IBM i Access for Windows OLE DB provider

Supports record-level access and SQL access to IBM® i database files. Use the ActiveX Data Objects (ADO) and the OLE DB interfaces to take advantage of this support.

The IBM i Access for Windows OLE DB Providers, along with the Programmer's Toolkit, make IBM i client/server application development quick and easy from the Windows client PC. The IBM i Access for Windows OLE DB Provider component gives IBM i programmers record-level access interfaces to IBM i logical and physical DB2® for i database files. In addition, they provide support for SQL, data queues, programs, and commands.

ADO and OLE DB standards provide programmers with consistent interfaces to IBM i data and services. All three of the providers (the IBMDA400, the IBMDASQL, and the IBMDARLA) handle all IBM i-to-PC and data type-to-data type conversions.

To install OLE DB Provider:
See the topics in the User's Guide on installing and removing features to install this provider.
Note: The OLE DB Provider is not installed if the computer does not have MDAC 2.5 or later installed, before installing the IBM i Access for Windows product. MDAC can be downloaded from the Microsoft Web site: www.microsoft.com/data/doc.htm.
To access OLE DB Technical Reference:
Start of changeThe IBM i Access for Windows OLE DB Technical Reference, which is shipped with the IBM i Access for Windows product, provides complete documentation of OLE DB Provider support. To access this information, select Start > Programs > IBM i Access for Windows > Programmer's Toolkit > OLE DB Provider Technical Reference.End of change
To install Programmer's Toolkit:
See the topics in the User's Guide on installing and removing features to install this toolkit.