Able to connect in SQL Developer but not in Toad - ORA-12154: TNS
My work place uses TOAD as the standard SQL tool to run against Oracle though I prefer to test out and use SQL developer.
When trying to connect to a database in TOAD i get the following error
ORA-12154: TNS: could not resolve service name
Im using the file in TNSNAMES.ORA, and I am able to connect via SQL Developer no problem.
Also in the same file, I am able to connect to other TNS names, but just not this one it seems.
I find this very odd, as it seems that for this one TNS name, i specifically can not connect via TOAD
I can connect to any other TNS via TOAD, and I can connect to it via SQL developer
I also tried a TNSPING and its coming back as OK so the server and connection seem right.
I am trying to connect to an Oracle 10g database with TOAD version 8.0.0.47
Any insight appreciated!