Use this procedure to configure the Oracle ODP.NET connection.
If you select
Oracle ODP.NET in the
Provider list, the Oracle Data Provider for .NET
(ODP.NET) Connection Properties dialog box displays.
To configure the Oracle ODP.NET connection:
-
On the General tab, perform the appropriate set of actions.
- In the
Data Source field, enter the server name.
- In the
User name field and
Password field, enter the user ID and
password to use for authentication when you log into the connection.
- Select the
Save my password option to save and encrypt
your password so that you do not need to enter the password each time you open
the connection.
-
On the Advanced tab, set the additional initialization properties
for your data.
-
Click
Test Connection to confirm that the connection
to your database connection works.
The PPM Datasource Management Tool displays a message box that
confirms the database connection.
-
Click
OK.
If the PPM Datasource Management Tool is unable to establish a
connection, return to the General tab and check your settings, or consult your
database administrator.