Creating custom connections to Oracle

You can specify the driver, data source and authentication details in a single connection string.

These are the elements of the string:

  • Provider (OraOLEDB.Provider)
  • Prompt or NoPrompt - If you specify Prompt, you are prompted for the password each time you log on to the database alias.
  • DataSource - The TNS name from tnsnames.ora
  • ID: User name
  • Password

Separate the elements with semi-colons. For example: Provider=OraOLEDB.Oracle;Prompt=NoPrompt;Data Source=RCPP_ORACLE;User ID="TSOwner";Password="[password]";

Note: If you have an existing Oracle database alias, the connection string is visible in the Properties pane when you select the alias in Database Structure.

To create a custom connection to Oracle:

  1. In the New Database Alias dialog, select Relational Provider from the Provider list.
  2. Select Custom from the Driver list.
  3. Specify the connection string in the Connection string field.
Parent topic: Creating a database alias