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:
Enter TNS in the server field
Give an arbitrary port number
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
By clicking Accept, you consent to our website's use of cookies to provide you with the most relevant experience by remembering your cookie preferences. More information can be found in section 4 of our Privacy Policy