Once you have fully completed your search filter for either the LDAP search or the MS Access database, you are ready to test the resulting record set.
1. Make sure you have defined a search filter and that you have specified the attributes you wish to see. For example, enter a search string to retrieve all the user groups starting with USR_:
"(&(objectCategory=group)(cn=USR_*))"
2. In the Attributes tab, select "Users- general information and click the Insert button.
3. Select the Run test tab. If you click the Test... button you should get a list of all the user groups starting with the string "USR_":
Run test on UMRA Service
Use this option to check if the search request can also be handled correctly by the UMRA service. If the UMRA service does not have sufficient security privileges to perform the LDAP search, you will receive an error.
Before you can start testing, you must have specified the database you want to access and define the SQL filter. We would advise you to perform the latter in MS Access and copy it into UMRA, since UMRA cannot "see" the actual database records.
Suppose you have the following MS Access table:
The following query has been used in the database query field. This should return a recordset containing all records in the table TestUsers.
If you now press the Run test tab and click the Test... button, the following data will appear:
Note: You can also test if the UMRA service has all priviliges needed to run the query. To do so, select the option Run test on UMRA Service. For instance, if the MDB file is located on a share to which the UMRA service has no access, you will receive the following error message:
