Unanswered oledb error 80040e55 on system.path

  • Monday, August 06, 2012 9:43 AM
     
     

    On windows 7 I started playing with the WSOleDB sample (http://msdn.microsoft.com/en-us/library/windows/desktop/dd940342(v=vs.85).aspx). It mostly works but I cannot get full path information on any of the search results!? Here is a sample query:

    SELECT System.ItemName, System.ParsingPath
    FROM SystemIndex
    WHERE CONTAINS('Microsoft')

    this fails with DB_E_BADORDINAL (0x80040E55). If I remove System.ParsingPath from the select clause it works (without paths of course). Using System.ItemUrl a slightly different error DB_E_ERRORSOCCURRED (0x80040E21) results. From the system path columns only this works:

    System.ItemPathDisplay

    but as the docs say this cannot be relied upon to create shell item information.

    So how do I get parsing path information for search results? Is anything wrong with my windows search indexer?

    thanks

    Nikos