Retrieving Auditing and Reporting Database Connection Settings (ODBCSettings)

The ICISite interface ODBCSettings property contains all auth manager settings in the form of string (attributes are separated with semicolons).

Signature:

STDMETHOD(get_ODBCSettings)(/*[out, retval]*/ BSTR *pVal);

STDMETHOD(put_ODBCSettings)(/*[in]*/ BSTR newVal);

For example, the logon name attribute for an AD\NTLM site is represented by the "ATTR=N" substring. N = 0, 1, 2, or 3:

• 0 = "NT4 Account Name"

• 1 = "Display Name"

• 2 = "User Principal Name"

• 3 = "Common Name"

This substring correlates to the Use this user attribute as logon name setting in the Windows Authentication Options dialog box. Other substrings appearing in the string depend on settings in the Windows Authentication Options dialog box. For example, if Create a virtual folder pointing to the user's home folder as defined in his/her AD profile is selected, the "CreateVirtualHF=1" substring is present in the ODBCSettings string; if Create a physical folder under the site root folder using the user's login name is selected, the "CreateVirtualHF=1" substring is not present in the ODBCSettings string.