Supports record-level access and SQL access to iSeries™ database files. Use the ActiveX Data Objects (ADO) and the OLE DB interfaces to take advantage of this support.
The iSeries Access for Windows® OLE DB Providers, along with the Programmer's Toolkit, make iSeries client/server application development quick and easy from the Windows client PC. The iSeries Access for Windows OLE DB Provider component gives iSeries programmers record-level access interfaces to iSeries logical and physical DB2 Universal Database™ (UDB) for iSeries database files. In addition, they provide support for SQL, data queues, programs, and commands. If you use Visual Basic, the Visual Basic Wizards make it simple and easy to develop customized, working applications.
ADO and OLE DB standards provide programmers with consistent interfaces to iSeries server data and services. All three of the providers (the IBMDA400, the IBMDASQL, and the IBMDARLA) handle all iSeries server-to-PC and data type-to-data type conversions.
- To install OLE DB Provider:
- When you install iSeries Access for Windows(or when you run Selective
Setup if iSeries Access
for Windows is
installed), select the Data Access component. Make sure that the OLE
DB Provider subcomponent also is selected. Note: The OLE DB Provider will not be installed if the computer does not have MDAC 2.5 or later installed, before installing iSeries Access for Windows. MDAC can be downloaded from Microsoft®: www.microsoft.com/data/doc.htm.
- To access OLE DB Technical Reference:
- The iSeries Access for Windows OLE DB Technical Reference, which is shipped with iSeries Access for Windows, provides complete documentation of OLE DB Provider support. To access it from the Programmer's Toolkit, select .
- To install Programmer's Toolkit and the iSeries ADO Wizards for Visual Basic:
- When you install iSeries Access for Windows (or when you run Selective Setup if iSeries Access for Windows is installed), select the Programmer's Toolkit component. See Install the Programmer's Toolkit for more information.
