-
Title
LDAP descripter in drop down is not displaying any database list -
Description
Able to connect to the Oracle 11g databases using Toad LDAP option ( Session | New Connection | LDAP Tab).
However the drop down box for "LDAP Descriptor" is not displaying any database name( it's empty).
It was working with Toad 10.1.1.8 but not with Toad 10.6.0 or Toad 10.6.1.
-
Resolution
RESOLUTION #1:
Please follow the steps below to fix the issue:
1. Exit Toad.
2. You will need to Edit the file Toad.ini:
a. For Windows XP: By default this file is located in (C:\Documents and Settings\\Application Data\Quest Software\Toad for Oracle\11.5\User Files" directory)
b. For Windows 7 : By default this file is located in (C:\Users\user_name\AppData\Roaming\Quest Software\Toad for Oracle\11.5\User Files" directory)
3. Edit the Toad.in as follow:
Find this
LDAP Filter=(objectclass=orclNetService)
Replace with this:
LDAP Filter=|(objectclass=orclNetService)(objectclass=orclService)
Note: (that ‘|’ character at the beginning is part of it)
RESOLUTION #2:Remove the TNS_Admin variable, if one is set.