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