Toad 8.6 and older versions are not compatible with LDAP.
Starting with Toad 9.0, LDAP connection is supported.
Connecting using LDAP
Toad officially supports Oracle names directory services. This support includes both Oracle OID and Microsoft Active Directory servers.
Oracle Instant Client LDAP support
.Instant Client LDAP support is dependent on specific LDAP DLL which Oracle does not install by default. The ORALDAPCLNT10.DLL (based on the client version) must be located in the same location as oci.dll file.
TNSNAMES.ora, LDAP.ora, SQLNET.ora must exist in the same location specified by the TNS_ADMIN system variable.
The LDAP drop down list in the Logon Dialog will not be populated, but connection can be carried out by manually enter the DB name into the 'Database field' on the logon screen.
To create a new connection using LDAP
1. Enter the name of the user in the box labeled User/Schema.
2. Enter the password for this user in the box labeled Password. For added security, characters will not appear as you type; asterisks will appear instead.
3. Click the LDAP tab.
4. Enter the LDAP Descriptor of the database you to which you want to connect.
5. The Connect As dropdown allows you to connect as either SYSDBA or SYSOPER if you have the appropriate permissions. The default for this box is Normal.
6. If you want to color-code this connection, select a color from the Color box drop down. (See Selecting Connection Color for more information.)
7. Click OK.
You can use the LDAP editor to edit your LDAP parameters. Toad supports both Oracle LDAP and Windows LDAP servers.
To access the LDAP Editor
. From the Server Login window, click the LDAP Editor button.
Backing up your LDAP File
It is recommended that you create a backup file of your LDAP file before you make any changes to it. This assures that if something goes wrong you can restore the original settings.
To create a backup file
. Click Create Backup File.
To restore from backup
. Click Restore Backup File.
Using the LDAP Editor
The top of the editor contains the path for the file you are editing. Below this is an editable list of directory servers, and the default administration context.
To add a directory server
1. In the Directory Servers area, click Add.
2. Enter the Host, Port and SSL Port information.
3. Click OK.
To set default administration contexts
Note: The default administration contexts apply to all servers listed in the Directory Servers area.
. In the Default Admin Context area, enter the contexts you want to use.
For more information about Admin contexts and Default admin contexts, please see your Oracle documentation.
To set server type
Note: The directory server types apply to all servers listed in the Directory Servers area.
. In the Directory Server Type box, click the dropdown and select the server type you want to use (either Microsoft Active Directory or Oracle Internet Directory).