Overview

Oracle Objects for OLE

Oracle Objects for OLE is a collection of programmable objects that simplifies the development of applications designed to communicate with an Oracle database. Oracle Objects for OLE is particularly well suited for any programming environment that supports Visual Basic custom controls OLE Automation. Oracle Objects for OLE consists of three principle components: the Oracle Object Server, the Oracle Data Control, and the
Oracle Objects for OLE C++ Class Library.

The Oracle Object Server

The Oracle Object Server is an OLE "In Process" server that supports a collection of programmable objects for Oracle databases running either locally or remotely. An OLE In Process server is a special kind of OLE server, running in a Windows DLL, that supports the OLE Automation interface. An OLE In Process server has no user interface and is not embeddable. You can access the Oracle Object Server through the Oracle Data Control, through any application that supports OLE Automation (such as in Visual Basic for Applications, in applications such as Microsoft Excel Version 5.0 and Access 2.0/7.0) and through the Oracle Objects for OLE C++ Class Library.

The Oracle Data Control

The Oracle Data Control is a Visual Basic custom control for use with development tools that support custom controls. If you are familiar with that data control, learning to use the Oracle Data Control is quick and easy.

The Oracle Objects for OLE C++ Class Library

The
Oracle Objects for OLE C++ Class Library is a collection of C++ classes that provide programmatic access to the Oracle Object Server. Although the class library is implemented using OLE Automation, neither the OLE development kit nor any OLE development knowledge is necessary to use it. In addition to the object classes, the class library provides a bound class, which allows controls such as text and list boxes to be linked directly to a field of a dynaset (columns in the database). The bound class supports late, runtime binding, as is available in Visual Basic. The Oracle Objects for OLE C++ Class Library is supported for Microsoft Visual C++ and the Microsoft Foundation Classes (for the bound class).

Oracle Objects for OLE, OLE and the Oracle Database

Relationships shows the high-level relationship between the Oracle Data Control, the Oracle Objects for OLE C++ Class Library, the Oracle Object Server, OLE, and the Oracle database.