Applies to the MS SQL Server connector only.
Symptom:
Your data can use the Flexi-DN data type for an multivalue attribute which contains a number of DN strings.
In Connector Xpress, the default converter adds single quotes to every value, which can cause problems with SQL Server.
Solution:
You can now select how to format the attribute before it is passed into the SQL query.
To make Connector Xpress generate the string with no quotes, use the flattening style SQLQUOTELESS.
Example: Using SQLQUOTELESS to generate a string with no quotation marks
In this example, the DN string look like this:
eTDYNObject001Name=1,eTDYNContainer001Name=Role Container
The default converter for the Flexi-DN data type extracts the role ID "1" from this full DN string.
If you add a Stored Procedure binding to this attribute, CA IAM Connector Server will generate a role ID string with each value enclosed with single quotes:
"'1', '2', '3', '4'"
When you use the flattening style SQLQUOTELESS, the role ID string is converted to the format that SQL Server expects:
"1, 2, 3, 4"
|
Copyright © 2014 CA.
All rights reserved.
|
|