/
Connecting an Oracle Database with TNS Names

Connecting an Oracle Database with TNS Names

Owned by Roman Villandry (Unlicensed)
Last updated: Jun 30, 2022 by Brandon Johnson (Unlicensed)

When connecting to an Oracle database that is using TNS names, there is no option to specify this in the standard database connection Wizard.

  1. Enter TNS in the server field
  2. Give an arbitrary port number
  3. Type the TNS name in the database field.

This should then allow you to proceed to the next page of the wizard where you can select from the available views.

Note:

When connecting to an Oracle database the drivers are not automatically installed, you will need to download and install them from https://cardexchange.sharepoint.com/:u:/s/Support/ES_gvbreSkhBooIeO15KQPMBcPP_9XVgGvhbzeVACMUzlg?download=1

Related content

Tech note 21_01 - Connecting Oracle 19C to producer
Tech note 21_01 - Connecting Oracle 19C to producer
Support Center
More like this
Technote 16/08 - Oracle TNS Names
Technote 16/08 - Oracle TNS Names
Support Center
More like this
Database_Connections
Database_Connections
User Guides
More like this
Producer Help - Using MS SQL Server
Producer Help - Using MS SQL Server
User Guides
More like this
Edit Card Definitions
Edit Card Definitions
User Guides
More like this
Producer Help - Database Connections
Producer Help - Database Connections
User Guides
More like this