ADSI 2.0, 2.5, and MDAC 2.1 Compatibility Issues

• Microsoft Site Server version 3.0
• Microsoft Site Server version 3.0, Commerce Edition

SYMPTOMS

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:

Microsoft OLE DB Service Components error '80040e21'

Set MyConnection = Server.CreateObject("ADODB.Connection")<BR/>
    MyConnection.Provider = "ADsDSOObject"<BR/>
    My Connection.Open "ADs Provider", "", "" 

Cannot Set Attribute Description

SAWIZARD: The New Membership Server Wizard cannot create or configure DS accounts for the selected services

CAUSE

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:

• Attempting to create more than one instance on the same computer that all point to the same LDAP directory.
• Creating an instance on computer A that points to an existing directory, and then deleting the instance on computer A and attempting to re-create the same instance, pointing to the same directory as before.

RESOLUTION

Issue #1: To resolve this issue, install ADSI 2.5.

Issue #2: ADSI 2.5 should be installed AFTER installation of Site Server 3.0, Commerce Edition (if applicable), and service pack 2. If ADSI 2.5 is installed prior to Site Server 3.0, there will be issues regarding Personalization and Membership, and the noted installation failure in Commerce Server.

Issue #3: Follow the steps listed in the WORKAROUND section below. This issue is scheduled to be resolved in Site Server 3.0 SP3.

Download and install ADSI 2.5 from the following Microsoft Web address:

http://www.microsoft.com/adsi

WORKAROUND

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.

Issue #3:

1. If you create more than one instance pointing to the same directory on the computer, stop all instances.



2. In MDM, go to the property page of the group(s). If AUO/Broker is to be created, the group is "GRPBRKR" appended with the computer name. If Direct Mail instance is to be created, the group is "GRPDM" appended with the computer name.



3. Click the Members tab on the properties. If there is more than one member to the group, write down all of the members on a piece of paper.



4. Delete the group(s) in MDM.



5. Re-run the New Membership Server wizard.



6. When the instance is created, go back into MDM and bring up property page for the same group(s). Add all the members that used to belong to the group back into the group.

STATUS

Microsoft has confirmed this to be a problem in Site Server version 3.0.

Additional query words:

Keywords          : SS3SP2Fix 
Version           : winnt:3.0
Platform          : winnt 
Issue type        : kbbug 

Last Reviewed: July 14, 1999