DBCS Data May Not Be Stored Correctly in the Membership Directory After MDAC 2.1 Update (247948)
The information in this article applies to:
- Microsoft Site Server 3.0
- Microsoft Site Server 3.0 Commerce Edition
This article was previously published under Q247948 IMPORTANT: This article contains information about modifying the registry. Before you
modify the registry, make sure to back it up and make sure that you understand how to restore
the registry if a problem occurs. For information about how to back up, restore, and edit the
registry, click the following article number to view the article in the Microsoft Knowledge Base:
256986 Description of the Microsoft Windows Registry
SYMPTOMS
After updating the MDAC 2.1 or later version on Site Server 3.0 LDAP Server, DBCS characters may not be stored correctly in the Membership Directory if SQL Server does not have the same code page as LDAP Server.
CAUSE
When using the MDAC 2.1 or later version, the SQL Server ODBC driver (version 3.70.0623 or later) or the OLEDB provider (version 7.01.0623 or later) translates character data from the client code page to the server code page automatically by default. This may cause a problem between Site Server LDAP and SQL server for Membership Directory if each server has the different code page. For more information on Auto translation, you can refer to the following Microsoft Knowledge Base article: 234748 PRB: SQL Server ODBC Driver Converts Language Events to Unicode
RESOLUTIONTo resolve this problem, obtain the latest service pack for Site Server version 3.0. For additional information, click the following article number to view the article in the
Microsoft Knowledge Base:
219292 How to Obtain the Latest Site Server 3.0 Service Pack
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was first corrected in Site Server 3.0 Service Pack 4.
Modification Type: | Minor | Last Reviewed: | 9/23/2005 |
---|
Keywords: | kbHotfixServer kbQFE kbbug kbfix kbQFE kbSiteServ300sp4fix KB247948 |
---|
|