When having an IFILE parameter within the tnsnames.ora, Toad does not recognize the parameter as valid.
WORKAROUND:
Since Windows Vista it is possible to create links (like in Unix/Linux) for files.
If creating a Link named tnsnames.ora in the $TNS_ADMIN folder that points to a file on the Network the drop-down in Toad should again show the database entries referenced.
"mklink tnsnames.ora \\Server\Freigabe\tnsnames.ora"
STATUS:
Waiting for a fix to be released in a future release of Toad for Oracle.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center