I have installed 64 bit Oracle Database 126.96.36.199.0 on a 64 bit Windows 7 Professional Laptop
I am able to tnsping and connect thru the command line sqlplus user/pass.
Now When I try to test odbc connection, i get the following error:
[Oracle][ODBC][Ora]ORA-12154: TNS could not resolve the connect identifier specified
I have fixed this issue by adding the following lines to "sqlnet.ora" file which exist under "C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN"
names.default_domain = world
note: world represent extension for your instance name (ex: x.world where x is your TNS name)