Hello,
I am new to Oracle. I tried searching but did not find anything about the specific issue that I am having. Probably because it is very basic.
I am trying to setup a DSN on my computer to connect to the companies Oracle database.
These are the steps I have taken:
- Installed Oracle Client 12.2
- Installed the Oracle ODBC driver.
- Installed Visual Studio 2013
- The driver shows up in the ODBC Data Source Administrator
- I was sent the TNS info for the database I am trying to connect
- When I try to Add a System Data Source I get the following error
I am unsure if I am using the right TNS name. I am using "Service Name" out of the snippet of code that I was sent.
(CONNECT_DATA=(SID=Service Name)
Any help would be much appreciated. Thank you!
