'%' 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 ("*").
RESOLUTIONTo 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
STATUSMicrosoft 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: | Minor | Last Reviewed: | 9/26/2005 |
---|
Keywords: | kbHotfixServer kbQFE kbBug kbsetup w2000setup KB268144 |
---|
|