Accessing the OO4O Automation Server

In order to connect to an Oracle database with the OO4O Automation Server, you must first create an instance of the server. In Visual Basic (VB), this is usually done by calling the CreateObject method, although the NEW keyword can also be used.

You can use the Visual Basic CreateObject method with two OO4O server objects. The interface of either of the following objects can provide access to OO4O and enable a connection to the Oracle database.

· OraSession

· OraServer

The CreateObject method uses the ID of the component and object as arguments.

Obtaining an OraSession Object

The following script demonstrates how to obtain an OraSession object in Visual Basic. OO4OSession is the object variable that holds an instance of the OraSession object.

Dim OO4OSession as Object

Set OO4OSession = CreateObject(“OracleInProcServer.XOraSession")

or

Dim OO4OSession as OraSession

Set OO4OSession = New OraSessionClass

or

Dim OO4OSession as New OraSessionClass

The following example demonstrates how to obtain an OraSession object in IIS Active Server Pages.

<OBJECT RUNAT=Server SCOPE=APPLICATION ID=OO4OSession PROGID="OracleInProcServer.XOraSession">

</OBJECT>

OracleInProcServer.XOraSession is the version independent program ID for OO4O that the Oracle client installation program registers in the Windows registry. It is the symbolic name for a globally unique identifier (CLSID) that identifies the OO4O component.

Obtaining an OraServer Object

You can also use the OraServer object interface for accessing the OO4O Automation Server.

Dim OO4OServer as Object

Set OO4OServer = CreateObject("OracleInProcServer.XOraServer")

Now you can connect to the Oracle Database. See Connect to Oracle Database.