Configure an Oracle Relational Connection

Before you can configure an Oracle database connection, the Oracle Data Provider for the .NET 12.1.0.2.1 framework or a newer version is required. If this is not installed, you are warned and you cannot add an Oracle database. If you upgrade or install the Oracle drivers, restart your server for the changes to take effect.

Important It is not possible to connect to an Oracle database with an Oracle 10g client in this way. Upgrade your Oracle client to the latest version to access the database.
  1. If you are creating a new connection, the Configure Oracle Connection appears after you complete the Add New Connection window. If you are modifying an existing connection, open the Configure Oracle Connection window by following these steps:
    1. On the Project tab, in the Configuration group, select Project Settings Project Settings icon.
    2. Click the Databases tab to view the databases settings.
    3. Under Relational Connections, select the connection you want to change.
    4. Click Properties.
  2. In the Oracle Server/TNS field, enter the name and TNS (Transport Network Substrate), or IP address and TNS of an Oracle server.
  3. In the Login Information group, type a User Name and Password if applicable.
  4. Optionally, you can review the Connection String field.

    This string shows the connection to the database and is defined by the other settings in this window. If you have specified a password, it is fully encrypted and cannot be viewed. You can edit the connection string as needed. If you change any of the options in the window, a new string is generated and overwrites any changes you made.

  5. Click Test Connection to verify that the connection works.
  6. Click OK.

    If the connection works, the Configure Oracle Connection window closes. If the connection fails, an error appears and the Configure Oracle Connection window remains open until the connection works.

    If you are unable to get the connection to work, click Cancel to close the window without saving the changes.

  7. Optionally, click OK to close the Project Settings window.
  8. Save the changes to your project.