You can select an SQL Query Scheme using the User Directory Dialog.
To select an SQL Query Scheme
The SQL query scheme is saved to the directory connection.
Note: If you are using MS SQL Server, and your queries are returning names that include the apostrophe character (for example, O'Neil), you must replace any instance of '%s' in the query strings to ''%s''. To avoid this problem, base your queries on user IDs that do not include apostrophes, or modify the query strings that include '%s'.
Copyright © 2010 CA. All rights reserved. | Email CA about this topic |