I have installed the Oracle ODBC client on a system. TNSPING against the datasource works, but when I try to set up ODBC, it doesn't work. In the ODBC Driver Configuration box, the drop down for TNS Service Name is empty. I tried manually entering the name and other information, but when I got to Test Connection, I get the error:
[Oracle][ODBC][Ora]ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA.
Contrary to all the other cases I have found about this, TNSPING does work and returns the correct results. I am also using the correct ODBC version. More specifically, on this 64-bit OS I also tried the 32-bit ODBC and it has the same problem.