Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 179237 - Last Review: December 3, 2003 - Revision: 3.1
PRB: Searching Phrases with Numbers in MSIDXS OLE DB Provider
This article was previously published under Q179237
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.
This is a problem in the Index Server 2.0 query mechanism. Using an HTX/IDQ
sample reproduces the same behavior.
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
Microsoft is researching this problem and will post new information here in
the Microsoft Knowledge Base as it becomes available.
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.
For more information on Index Server, please see the following articles in
the Microsoft Knowledge Base:
179326Â
(http://kbalertz.com/Feedback.aspx?kbNumber=179326/EN-US/
)
FILE: Idxadovb.exe: Using Index Server OLE DB Provider and
ADO
178849Â
(http://kbalertz.com/Feedback.aspx?kbNumber=178849/EN-US/
)
INFO: Index Server OLEDB Provider Cannot Be Installed
Separately
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
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
|
dicky2
- rs0174a5987 NOSPAM-AT-NOSPAM blueyonder.co.uk
|
Reported as Irrelevant
|
| Written:
10/25/2004 8:15 AM |
|
|
|
dicky2
|
Reported as Irrelevant
|
| Written:
10/25/2004 8:19 AM |
|
|