Article ID: 216709 - View products that this article applies to.
This article was previously published under Q216709
This article has been archived. It is offered "as is" and will no longer be updated.
Site Server Membership Samples and Commerce Server Sample Sites use Active Directory Service Interfaces (ADSI) 2.0. There are several known compatibility issues with ADSI 2.0 and MDAC 2.1 that occur in the Site Server Membership Samples and Commerce Server Sample Sites.
Issue #1: When you conduct dynamic queries from the Membership Sample Site, an OLE DB error occurs.
When you conduct dynamic queries to the LDAP directory through ADSI, the following error occurs:
The following ADSI connection fails:
Microsoft OLE DB Service Components error 80040e21
Issue #2: ADSI 2.5 installation causes failure during Commerce Server installation.
The following error occurs during the configuration of the Trey Research sample site:
Issue #3: SAWIZARD Fails to configure the directory after installing ADSI 2.5. The following error occurs:
Cannot Set Attribute Description
SAWIZARD: The New Membership Server Wizard cannot create or configure DS accounts for the selected services
Issue #1: This error corresponds to a condition where the data type of the parameter being passed to the stored procedure does not match the data type that the stored procedure is expecting. This occurs because ADSI 2.0 and MDAC 2.1 are not compatible.
Issue #2: This error occurs when ADSI 2.5 has been installed prior to Site Server 3.0. Site Server 3.0 installs ADSI 2.0 and overwrites ADSI 2.5. Although no error messages occur during the Site Server 3.0 installation, subsequent Commerce Server installations will fail when the sample sites are being configured for the LDAP directory.
Issue #3: This error is caused by ADSI 2.5 and Site Server 3.0 compatibility issues that are not resolved with Site Server 3.0 SP2. The following conditions will produce this error:
To resolve this problem, obtain the latest service pack for Site Server 3.0. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/219292/EN-US/ )How to Obtain the Latest Site Server 3.0 Service Pack
For All Issues: MDAC 2.1 is delivered with SQL Server 6.5 SP5 as a separate install, and in SQL Server 7.0 as a mandatory install. As a result of the LDAP component using ADSI 2.0, if you want to install MDAC 2.1 on your SQL Server 7.0 or SQL Server 6.5 SP5 computer, you must run SQL Server on a separate computer than the LDAP service, or install ADSI 2.5.