YOUR ARE VIEWING ARTICLE

Oracle TNS Names

Oracle TNS Names

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

You can however follow the below steps to add the details:

  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 here: ODAC112.zip

TOPICS

CATEGORY

AUTHOR
Support Team

PUBLISHED
October 12, 2016

MODIFIED
April 27, 2022

US business only within scope

ISO/IEC 27001:2013 

United States

2010 Elkins Way, Suite 1122
Brentwood, CA 94513

Monday – Friday
9am – 5pm (EST)
+1 (925) 529 4999

Netherlands

Smallepad 32
3811 MG Amersfoort

Monday – Friday
9am – 5pm (CET)
+31 (0)20 2251 447

© 2023 CardExchange Solutions, Inc.