Page 1 of 1

Unable to use TNS for new connections

PostPosted: Thu Mar 17, 2016 12:39 am
by JaimeW
I have been playing around with your tool and overall I like it, but I haven't really been able to spend a lot of time with it considering that creating new Oracle connections seems to be problematic.

We have a global TNSNames.ora file, and when attempting to create a new connection using that file I run into issues. The drop down list populates correctly, I choose my TNSName, and enter a username/password, but when I test the connection, I get the below error. This occurs for any number of entries in our TNS names. I can work around this by manually entering the data, but I would like to use TNS entries so that any updates made to our global TNS names will be picked up automatically. Is there something that needs to be set, or am I seeing some error with the TNSNAMES.ora parsing?

SQLRecoverableException: IO Error: could not resolve the connect identifier "XXXXX"