DataGrid: tnsnames.ora not found

Answered

I am new to Oracle and trying to figure out how to connect DataGrid to it.  Here is a screen shot of where what I am seeing:

For what it is worth, the tnsnames.ora works find for Oracle SQL Developer, so I don't know why DateGrip is having problems.

2 comments
Comment actions Permalink

>I did use the [...] button and still got the message, I finally got things working when I set the TNS_ADMIN environment variable and the error message went away. Now I do have to manually add the alias, but it is working!

 

I think the point was to use [...] to specify path to TNSADMIN. The [...] helps you to avoid path issues.  Refer to our help https://www.jetbrains.com/help/datagrip/connecting-to-a-database.html#connect-to-oracle-database and Oracle help https://docs.oracle.com/database/121/NETRF/tnsnames.htm#NETRF007

0

Please sign in to leave a comment.