Visual studio 2010  ODAC Oracle ORA-12154
===

I can connect to remote Oracle db using Oracle SQL Developer after tuning TNSNAMES.ora. I can also connect to remote Oracle db using export import vizard in SQL server. 
When do tnsping sourcename on command prompt, I get the correct response. This shows my TNSNAMES is correct.

But when I try to add datasource in Visual Studio 2010 under server explorer, it gives me ORA-12154!!

Based on couple of suggestions in forums, added below line to sqlnet.ora
NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, HOSTNAME) but still same error!

The Oracle Data Access Components (ODAC) 11.2.0.3 is installed.

thanks in advance.