Execute the following from a command prompt: drive:\path>įile provided to register OO4O configuration information. Table 1-1 Redistributable File Locations FilesĮxecute the following from a command prompt:Įdit for the correct ORACLE_HOME location and HOME ID on your computer. Microsoft Internet Information Server (IIS) The OO4O automation server requires an application that supports COM Automation such as: Oracle Universal Installer ensures that the RSFs are installed as part of the OO4O installation. Oracle supports 32-bit Oracle Objects for OLE on x86, AMD64, and Intel EM64T processors on these operating systems.Ī local or remote Oracle database (Oracle9 i Release 2 or higher)
The following system requirements are necessary to install Oracle Objects for OLE:ģ2-bit: Windows 7 (Professional, Enterprise, and Ultimate Editions), Windows Vista (Business, Enterprise, and Ultimate Editions), Windows Server 2008 (Standard, Enterprise, Datacenter, Web, and Foundation Editions), Windows Server 2003 R2 (all editions), Windows Server 2003 (all editions), or Windows XP Professional Edition. Oracle Objects for OLE is not supported on Windows 圆4 operating systems. Communication between data-aware controls and a Data Control is governed by a protocol specified by Microsoft. If you are familiar with the Visual Basic data control, learning to use Oracle Data Control is quick and easy. The Oracle Data Control is compatible with the Microsoft data control included with Visual Basic. If a user changes data in a control that is bound to a data control, the changes are automatically reflected in the underlying dynaset and database. When record movement occurs, data in bound controls stay synchronized with the current record of the dynaset. To create a dynaset with a data control, set the Connect, DatabaseName, and RecordSource properties, and execute the Refresh command.Ī data control enables you to bind it to other controls that display a field, a record, or multiple records of the underlying dynaset. Oracle Data Control is an ActiveX control that is designed to simplify the exchange of data among an Oracle database and visual controls such as edit, text, list, and grid controls in Visual Basic and other development tools that support custom controls.Ī data control enables you to perform most data access operations without writing any code. Thread safety, allowing safe access to automation objects in multithreaded environments.
The Oracle code wizard for stored procedures, which automatically generates OO4O code to execute PL/SQL or Java stored procedures. Support for asynchronous processing of SQL statements and PL/SQL blocks.Įasy to use interface for describing schema objects. Support for publishing, detecting, and subscribing to database events. Seamless access to instances of advanced Oracle data types: Support for COM+ and Microsoft Transaction Server (MTS) co-ordinated transactions. Support for array fetches, updates, and inserts resulting in reduced network round-trips.Ĭonnection pooling to allow development of scalable middle tier application components, such as IIS Active Server Pages, that use and serve dynamic content stored in Oracle databases.
This includes support for the Oracle data types, such as PL/SQL cursors, that are needed for parameters of PL/SQL stored procedures. PL/SQL support for execution of PL/SQL anonymous blocks and stored procedures. Tunable client-side, scrollable and updatable cursors for easy and efficient access to result sets of queries.
Oracle 11 g is grid enabled, allowing developers to take full advantage of grid support without changes being required to existing code.
See Also: "Introduction to Automation Objects"