Microsoft KB Archive/838116

= Data casting between SQL data types and ADSI data types in SharePoint Portal Server 2003 =

Article ID: 838116

Article Last Modified on 9/30/2004

-

APPLIES TO


 * Microsoft Office SharePoint Portal Server 2003

-





SUMMARY
This article contains information about some things to consider if you map Active Directory directory service properties when you import user profile information from Active Directory to Microsoft Office SharePoint Portal Server 2003. This article also contains information about data casting that is supported between SQL data types and Active Directory Service Interfaces (ADSI) data types.



MORE INFORMATION
The following are some things to consider if you map Active Directory properties in SharePoint Portal Server 2003:
 * If you map properties that use different data types, the values of the properties may be modified in certain situations. For example, if the property in Active Directory uses a string data type and you map it to a property that uses an integer data type, all non-integer values are converted to use 0 (zero). For example, if the string is ABC, the value of the property is changed to 0 (zero) after the property is mapped.
 * When you map properties, try to use the native data property type where it is possible. For example, if the property of the user profile in Active Directory uses an integer data type, map the property to a property that uses the integer data type in the user profile. Do not map the property to a property that uses a different data type. For example, do not map the property to a property that uses the string data type.

The following table contains information about data casting that is supported between SQL data types and ADSI data types when you import user profile information from Active Directory to SharePoint Portal Server 2003:

Note An asterisk character (*) means that conversion is not supported.

Keywords: kbinfo kbtshoot KB838116

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.