OS : Windows Vista Enterprise
Oracle : v 10.2.0.3.0
ODAC : 5.80.0.42
We cannot get ODAC to connect to Oracle on Vista. When we try to do so, we continually get "ORA-12154: TNS:could not resolve service name ..." errors.
The following things have been observed :
1. We can happily connect via SQL* Plus using the same login credentials.
2. We can tnsping the connection.
3. With a simple test app, TOraSession + ConnectionDialog, no entries are appearing in the Server drop down box.
4. There are no problems connecting on XP / 2003.
5. "TNSNAMES" is listed as one of the values of the NAMES.DIRECTORY_PATH parameter in the Oracle Net profile (SQLNET.ORA)
6. TNSNAMES.ORA file exists and is in %ORACLE_HOME\Network\Admin directory.
This is causing us a major headache, as one of our new customers is using Vista and are urgently waiting to use our ODAC based software.
Please can you offer suggestions on how we can resolve this?
Paul