Once you have obtained an interface, you can use it to establish a user
session in an Oracle database by invoking the OpenDatabase method.
Set EmpDb= OO4OSession.OpenDatabase("ExampleDb", "Scott/Tiger", 0)
or
Set EmpDb= OO4OServer.OpenDatabase("Scott/Tiger")
The variable EmpDb represents a user session. It holds an OraDatabase interface and can be used
to send commands to the Oracle database using ExampleDb for the network connection aliasand "scott/tiger" for the username and password.
The OraServer interface allows multiple user sessions to share a physical
network connection to the database server. This reduces resource usage on the
network and the database server, and allows for better server scalability. However,
execution of commands by multiple user sessions is serialized on the
connection. Therefore, this feature is not recommended for use in multi-threaded
applications in which parallel command execution is needed for performance.
The following code shows how to use the OraServer interface to establish two
user sessions.
Set OO4OServer = CreateObject("OracleInProcServer.XOraServer")
OO4OServer.Open("ExampleDb")
Set EmpDb1 = OO4OServer.OpenDatabase("Scott/Tiger")
Set EmpDb2 = OO4OServer.OpenDatabase("Scott/Tiger")
NOTE: You can also obtain user sessions from a previously created pool of
objects. For a discussion on how to use this feature, see Using the Connection Pool Management Facility.