The driver could not find tnsnames.ora or could not find the alias in the tnsnames.ora. Most common reasons:
- multiple oracle homes e.g. for the database and for the client (use ora home selector in ora SW menu to select the right one or put the alias to both the files )
- wrong ORACLE_HOME set (check the registry)
- tnsnames.ora in a wrong location (must be %ORACLE_HOME%/network/admin)
- the TNS_ADMIN environment variable set (unset or set to the directory with tnsnames.ora)
- the NAMES.DEFAULT_DOMAIN parameter set in the sqlnet.ora file (unset)
Ales
The whole difference between a little boy and an adult man is the price of toys