TNS Service Name drop list empty in Windows 10 64-Bit

User_AUZE8

When I attempt to create an ODBC connection under System DSN, the TNS Service Name drop down list is blank.

I manually added a database name and credentials (works in SQL Developer) and the following error appears:

I'm running Windows 10 Enterprise 64-Bit and Oracle12c 32-Bit.

What do I do?

Billy Verreynne

Try the following.

Locate the TNSNAMES.ORA file on your system and get the directory.

Add environmental variable TNS_ADMIN and set it to this directory.

And why use 32bit Oracle? Will not work for 64bit software.

User_AUZE8

https://community.oracle.com/tech/developers/discussion/comment/16780432#Comment_16780432

Thanks! In our workspace, we use 32-Bit and 64-Bit version of Oracle based on the needs of the application like SAS 32-Bit or 64-Bit needing a matching Oracle client.

This is the path for TNSNAMES.ORA:

I created this under User variables:

Is this correct?

Billy Verreynne

Yep - see if that works?

TNS_ADMIN overrides the path to use for the TNSNAMES.ORA file, and explicitly sets it - which should enable the OCI driver that is loaded by ODBC to find the file and enumerate the aliases in it.

User_AUZE8

https://community.oracle.com/tech/developers/discussion/comment/16780501#Comment_16780501

Will test this today and report back.