I'm running Win7x64 with Oracle client. I can connect to the particular instance using TNSNAMES.ora fine from: Sqlplus and Toad. When I try to create a new DataSource in VS2005, I get the ORA-12154.
I tried the following:
1. Added WRITE security on ORACLE_HOME folder.
2. Added NAMES.DEFAULT_DOMAIN to SQLNET.ora
3. Created another TNSNAMES entry with FQDN as #2 above.
I also downloaded: ODTwithODAC1020221.exe but when I installed, I received the following:
Starting Oracle Universal Installer...
Checking installer requirements...
Checking operating system version: must be 4.0, 5.0, 5.1, 5.2 or 6.0 . Actua
Exiting Oracle Universal Installer, log for this session can be found at C:\Prog
ram Files (x86)\Oracle\Inventory\logs\installActions2011-05-17_12-00-48PM.log
Please press Enter to exit...