OLEDB + Indexing Service = a little problem!!!

Hi people,

I really hope you'll help me!!

Here we try to query Microsoft Indexing Service!

At first we use ADO, it works great but with a little problem!

So We try to go directly trough OLEDB using the Microsoft sample... It solved the ADO problem but a new problem apears!!

It seems that when using OLEDB to do SQL query on Microsoft Indexing Service, the "OR" operator cause a 0 row returned!!!???

So the the following Query return 0 row... But it should!!

Select Path
From OurCatalog..SCOPE()
Where Filename LIKE '%.txt' OR
Filename LIKE '%.jpg'

We try this query using ADO and it work well... It return some rows!!

Could you give me some input to help me please? I really don't understand whats the matter!!

Thanks
Eric Forget
.

Relevant Pages

  • OLEDB + Indexing Service = Little problem!!!
    ... At first we use ADO, it works great but with a little problem! ... It seems that when using OLEDB to do SQL query on Microsoft Indexing Service, the "OR" operator cause a 0 row returned!!!??? ... Filename LIKE '%.jpg' ...
    (microsoft.public.inetserver.indexserver)
  • RE: ODBC query in VB code Need HELP
    ... Everything for ADO is in the first 2 messages that I gave you. ... Since your pass-through query already exists (including the ... Dim STRSQL As String ...
    (microsoft.public.access.formscoding)
  • Re: Connecting to Query
    ... practice examples of the ADO Command, Parameters, etc. you explained below. ... Second, with the selected territory ... >> combo box to select a product from a query based primarily on a link ...
    (microsoft.public.access.formscoding)
  • Re: On ADSI and LDAP
    ... the problem is how can I retrieve the value for myuser using the ... would be more efficient to use ADO to query AD for the attributes values. ... For more on using ADO, ... Dim adoCommand, adoConnection, strBase, strFilter, strAttributes ...
    (microsoft.public.scripting.vbscript)
  • Re: cant get query to run over ADO, but works fine in Access inte
    ... Thanks for the suggestions, Richard. ... the query so that unchanging parts of it are stored as a query with the part ... As I've had trouble with synchronizing ADO ... > Execute method of the ADO Connection object, but the issue is the same - you ...
    (microsoft.public.data.ado)