Establishing a connection to Personal Oracle 8

Article ID: 1116
Last updated: 05 Feb, 2008
Article ID: 1116
Last updated: 05 Feb, 2008
Revision: 1
Views: 4184
Posted: 27 May, 1998
by Dean J.
Updated: 05 Feb, 2008
by Dean J.
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.

This article was:   Helpful | Not helpful
Report an issue
Article ID: 1116
Last updated: 05 Feb, 2008
Revision: 1
Views: 4184
Posted: 27 May, 1998 by Dean J.
Updated: 05 Feb, 2008 by Dean J.

Others in this category