'%' Wildcard Operator No Longer Works in Access Multiselect Query with Windows 2000 Server Service Pack 1 (268144)



The information in this article applies to:

  • Microsoft Windows 2000 Server
  • Microsoft Windows 2000 Advanced Server

This article was previously published under Q268144

SYMPTOMS

When you install Microsoft Windows 2000 Server Service Pack 1 on a computer that is running Windows 2000 Server and Microsoft Site Server 3.0 Service Pack 3, the FastADS object's GetInfo function may stop retrieving information. When you create the FastADS object from the Fastads.asp file, you publish it to the Inetpub\Scripts folder, and then you browse to http://<Your server>/Scripts/Fastads.asp, no information may appear. The following is an example of the contents of the Fastads.asp file:
<%
' FastADS.dll == CADSContainer.CADSContainer.1
Set oADSContainer = Server.CreateObject("CADSContainer.CADSContainer.1")
oADSContainer.Authenticate "cn=administrator,ou=members,o=Yourorganization", "password", 0
oADSContainer.GetInfo "LDAP://ServerName:1002/ou=members,o=Yourorganization", "%(&(cn=*)(objectClass=member))"

for each oUser in oADSContainer
oUser.GetInfo ("")
response.write (oUser.GetEx("cn")(0) & "<br>")
next
%>
				

CAUSE

This behavior can occur because of a change in the syntax of multilevel select queries that use the Microsoft Access driver. In Windows 2000 Server, wildcard searches use the percent ("%") symbol, but in Service Pack 1, wildcard searches require an asterisk ("*").

RESOLUTION

To resolve this problem, obtain the latest service pack for Windows 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

260910 How to Obtain the Latest Windows 2000 Service Pack

STATUS

Microsoft has confirmed that this is a problem in Microsoft Windows 2000 Service Pack 1. This problem was first corrected in Windows 2000 Service Pack 2.

MORE INFORMATION

This behavior can occur in any scripting application that uses the percent sign ("%") as a wildcard operator instead of the asterisk ("*").

Modification Type:MinorLast Reviewed:9/26/2005
Keywords:kbHotfixServer kbQFE kbBug kbsetup w2000setup KB268144