TNSNames.ora doesn't appear when setting up a oracle odbc driver connection

Question

I want to connect an ASP application with my Oracle database, and i've readed that I have to set up a connection with my Oracle DB with ODBC driver to achieve it.

The problem is, that when I create the new ODBC connection, it asks for the TNSNames, and my the connection that I have in my TNSNames.ora doesn't appear in the drop list (it appears empty).

Im trying to create the connection going to the ODBC configuration in Control Panel.

Someone has any idea on how can I solve this?

Thanks in advance, Khor

Solution

Okay, I finally solved it.

What worked was creating a windows enviroment variable called TNS_ADMIN with the path to my admin folder on the oracle directory.

TNS_ADMIN: "C:\oracle\product\10.2.0\client_2\network\admin"

That solved the problem.

Comments

[Malvineous]

Thanks for the example - I'd set TNS_ADMIN to the path and filename of tnsnames.ora but I should have only put in the path, without the tnsnames.ora on the end!