Microsoft KB Archive/268144

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

Article ID: 268144

Article Last Modified on 2/23/2007

-

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:///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(&quot;CADSContainer.CADSContainer.1&quot;) oADSContainer.Authenticate &quot;cn=administrator,ou=members,o=Yourorganization&quot;, &quot;password&quot;, 0 oADSContainer.GetInfo &quot;LDAP://ServerName:1002/ou=members,o=Yourorganization&quot;, &quot;%(&(cn=*)(objectClass=member))&quot;

for each oUser in oADSContainer oUser.GetInfo (&quot;&quot;) response.write (oUser.GetEx(&quot;cn&quot;)(0) & &quot; &quot;) 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 (&quot;%&quot;) symbol, but in Service Pack 1, wildcard searches require an asterisk (&quot;*&quot;).



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 (&quot;%&quot;) as a wildcard operator instead of the asterisk (&quot;*&quot;).

Keywords: kbhotfixserver kbqfe kbbug kbsetup KB268144

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.