Oracle Programming in Windows Environment

Oracle's support for Windows: pro*c/c++ JAVA,JDBC/SQLJ Oracle Objects for OLE (oo4o) Oracle Provider to OLE DB Oracle Data Provider for. NET com/com+ A Utomation Feature tools,services for Microsoft Transaction Server

Oracle Objects for OLE (oo4o)

OO4O supports Microsoft's COM automation and Acitvex technology, allowing users to use any programming language or scripting language to obtain data stored in Oracle databases, including VB, VC, VBA, VBScript, JavaScript, etc.

OO4O provides the following parts:
–oracle Objects for OLE in-process automation Server
–oracle Data Control
–oracle Objects for OLE C + + Class Library

Beginning – Windows COM Data Access

–oo4o Software hierarchy diagram

oo4o Introduction Oracle Objects for OLE in-process Automation Server is a set of COM automation objects that connect to an Oracle database, execute SQL statements, and Pl/sql to obtain the resulting data after the execution of the statement. Unlike other COM-based database connection APIs, such as Microsoft's Ado,oo4o, which was created specifically for Oracle databases, it has been specially optimized to obtain some proprietary features of Oracle data that are much better performance than clunky ODBC or JDBC. Oracle Data Control is a ACTIVX program designed to simplify data transfer between visual controls, such as DBGrid, and databases.

Oracle Data Control enables the majority of data operations without writing any program code.
-Create a dynaset control
-Set Connect, DatabaseName, RecordSource properties
-Execute the Refresh command

You can bind a field, a record, or multiple records in dynaset for a control, which automatically completes data synchronization between the database, dynaset, and controls. Oracle Objects for OLE C + + Class library is a collection of C + + classes that provides a programming interface to the OO4O Automation server, which eliminates the need to master OLE programming knowledge. Provides a bound class that allows a control (such as a text box, list, and so on) to be a dynaset field (that is, a column of a table in the database). It also allows this binding process to be performed at run time. VC + + also supports Oracle Objects for OLE C + + Class Library.

Windows COM Data Access

Interpretation of the Oo4o class: Orasession: The highest level object in an application that manages the collection of Oradatabase, Oraconnection, and Oradynaset objects. An application should have only one of the objects. Oraserver: Represents a physical connection with a database instance Oradatabase: Represents a user session and is used to send commands orasqlstmt: An SQL statement oradynaset: Data snapshot oraparameters: parameters, Primarily used to store host variables in SQL statements.

odp–oracle Data Provider for. NET

Microsoft in. NET Architecture proposed to unify the database access technology ado.net. It contains a set of classes that are used to access the database. However, there is a problem accessing the database in Unified mode: 1. The inefficiency caused by the addition of too many layers; 2. Unique features provided by individual database vendors are inaccessible. To this end, each database manufacturer to imitate Microsoft's Ado.net, proposed its own to the. NET schema, the database access support. For example, Oracle Company's odp.net. Oracle is oriented to Microsoft's. NET environment and provides Oracle data Provider for. NET, which supports operating the ODP of data in an Oracle database. NET can consist of four parts:
–oracle Developer Tools for Vs.net
–oracle Providers for ASP.net
–oracle Database Extensions for. NET
–oracle Data Provider for. NET

Odp.net

Windows is based on. NET architecture provides more adp.net hierarchies, resulting in lower efficiencies, and Oracle's odp.net alleviates this problem.