PRB: Searching Phrases with Numbers in MSIDXS OLE DB Provider

Last reviewed: March 6, 1998
Article ID: Q179237
The information in this article applies to:
  • Microsoft OLE DB Provider for Index Server 2.0

SYMPTOMS

When using ActiveX Data Objects (ADO) with the OLE DB Provider for Index Server (MSIDXS) to query the contents of Index Server and you use a phrase where the first word starts with a number, Index Server may return incorrect hits. For example, when you search for the phrase '"32MB RAM"', Index Server may produce extra hits containing documents with just "RAM". The query '"32MB and RAM"' works correctly. Searching for other phrases such as '"SQL Server"' also works correctly.

CAUSE

This is a problem in the Index Server 2.0 query mechanism. Using an HTX/IDQ sample reproduces the same behavior.

RESOLUTION

You can work around this problem by adding an additional word to the beginning of the phrase (for example, CONTAINS('"the 32MB RAM"') > 0 ). The following query works correctly:

   SELECT Filename, Path, Size, Write FROM Scope('"/"') WHERE
   CONTAINS('"the 32MB RAM"') > 0

STATUS

Microsoft is researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Steps to Reproduce Behavior:

Use ADO and the MSIDXS provider to submit the following query with different search phrases:

   SELECT Filename, Path, Size, Write FROM Scope('"/"') WHERE
   CONTAINS('"32MB RAM"') > 0 ORDER BY Filename

  • Search for CONTAINS('"32MB"') > 0 and the hits will be correct.

  • Search for CONTAINS('"32MB RAM"') > 0 and it hits the documents containing the phrase "32MB RAM". However, this query also hits many other documents containing the word "RAM", but without the phrase "32MB RAM".

  • Search for CONTAINS('"32MB and RAM"') > 0 and it hits the correct number of documents containing the word "RAM" and "32MB" that may occur together or at different places in the documents.

    REFERENCES

    For more information on Index Server, please see the following articles in the Microsoft Knowledge Base:

       ARTICLE-ID: Q179326
       TITLE     : FILE: Idxadovb.exe: Using Index Server OLE DB Provider and
                   ADO
    
       ARTICLE-ID: Q178849
       TITLE     : INFO: Index Server OLEDB Provider Cannot Be Installed
                   Separately
    
    
    Keywords          : oledbProvIndex
    Technology        : ole
    Version           : WINDOWS:2.0
    Platform          : WINDOWS
    Issue type        : kbprb

  • ================================================================================


    THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

    Last reviewed: March 6, 1998
    © 1998 Microsoft Corporation. All rights reserved. Terms of Use.