I cannot establish a connection using Personal Oracle 8.
One difficulty with Oracle 8 involves determining the parameters for establishing a connection.
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
Personal Oracle has several predefined user / password combinations. For this example the
P08 combination will be used.
Write the following code:
RWDBDatabase db = RWDBManager::database("oracle", "test", "P08", "P08", "");
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.