Establishing a connection to Personal Oracle 8

Problem

I cannot establish a connection using Personal Oracle 8.

Cause

One difficulty with Oracle 8 involves determining the parameters for establishing a connection.

Action

To connect to Personal Oracle 8:

Obtaining the needed information

Determine the Server Name of the Database you want to connect to by using the Oracle Net 8 Easy Configuration. On the Oracle Service Name Wizard window, the edit box below New Services Name contains the name of the database. In this example, the name is going to be test.

Personal Oracle has several predefined user / password combinations. For this example the P08 / P08 combination will be used.

To connect to Personal Oracle 8 using DBTools:

Write the following code:

RWDBDatabase db = RWDBManager::database("oracle", "test",
"P08", "P08", ""); 

To connect to Personal Oracle 8 using Object Factory:

Start Object Factory and go to Setup -> Database samples.... Enter the data as shown below.

When you click OK you should see Object Factory creating a set of sample tables in Oracle.