When saving the default home, it always reverts back to the 'Oracle Root' after the first connection. All subsequent connections don't allow you to change the "Connection using" setting.
There is only one client installed on the system.
A TNS_ADMIN registry key is set in Oracle implementation (which may have the path to the central TNSNAMES.ORA file). This Entry is in the Home0 Key and is not directly in the Oracle root key.
Toad recognizes both the Home# and the Root. With only one client installed Toad takes the Home0 and Oracle Root as the same, but with tns_names setting specified in only Home0, Toad defaulting to root may not enable a connection down the specified path.
****WARNING: Using Registry Editor incorrectly can cause serious problems that can damage the operating system and the software installed. Quest cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.****
WORKAROUND 1:
Add a tns_admin key to the Oracle root along with the HOME# to specify your tnsnames.ora file location:
1. Close out of Toad.
2. Go to Start | Run and type 'regedit'.
3. Go to HKEY_LOCAL_MACHINES | Software | ORACLE
4. On the right hand side, add a "TNS_ADMIN" string
5. Double-click on the "TNS_ADMIN" entry and enter the new directory path that leads to the TNSNAMES.ora file that you wish to use and click "OK". (Do not include the actual file name in the path.)
WORKAROUND 2:
Add a tns_admin string to your Windows environment settings:
1. Right-click on My Computer and select Properties.
2. Select Advanced tab
3. Select Environmental Variables
4. Select New under System Variables
5. Create the tns_admin sting and enter the new directory path that leads to the TNSNAMES.ora file that you wish to use. (Do not include the actual file name in the path.)
STATUS:
An enhancement request has been submitted to Development for consideration in future release of Toad for Oracle.
