PRB: Searching Phrases with Numbers in MSIDXS OLE DB Provider (179237)
The information in this article applies to:
- Microsoft OLE DB Provider for Index Server 2.0
- Microsoft Data Access Components 2.1
- Microsoft Data Access Components 2.5
- Microsoft Data Access Components 2.6
This article was previously published under Q179237 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.
REFERENCES
For more information on Index Server, please see the following articles in
the Microsoft Knowledge Base:
179326
FILE: Idxadovb.exe: Using Index Server OLE DB Provider and
ADO
178849
INFO: Index Server OLEDB Provider Cannot Be Installed
Separately
Modification Type: | Major | Last Reviewed: | 12/3/2003 |
---|
Keywords: | kbprb KB179237 |
---|
|