TNSNames.ora does not appear when setting up odacc oracle driver connection

Question

I want to connect an ASP application with my Oracle database, and I read that I need to configure a connection to my Oracle DBMS with the ODBC driver to achieve it.

The problem is that when I create a new ODBC connection, it queries TNSNames, and my connection, which I have in my TNSNames.ora, does not appear in the forwarding list (it seems empty).

I am trying to create a connection to an ODBC configuration in the control panel.

Does anyone have an idea how I can solve this?

Thanks in advance, Poor

Answer 1

Ok, I finally decided this.

What worked by creating a windows environment variable called TNS_ADMIN using the path to my admin folder in the oracle directory.

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

This solved the problem.

Answer 2

You are probably using Win64.

If so, then you should configure ODBC DSN in the same Windows subsystem as Oracle. Verify that the Oracle client is installed in 32-bit or 64-bit.

There are 2 versions of odbcad32.exe on 64-bit versions of Windows. In c:\windows\system32 you will find 64 bits that configure ODBC for 64-bit applications and will use the configuration from the 64-bit version of the Oracle client. There is a 32-bit version in c:\windows\syswow64 that you must use to configure ODBC for 32-bit programs, including the 32-bit version of the Oracle client.