WDS 3 - RTW Final not indexing .xlsx file which have ODBC SQL Connection

Hello, Brandon recommended me posting this problem I noticed in the WDS 3 RTW.

Basically the WDS 3 RTW, and (Beta 2) cant index the contents of Excell new format (.xlsx), if the excell contains a ODBC (SQL database) connection.

The easy way to reproduce is to, create a new .xlsx file using Office 2007 B2TR, create a ODBC SQL connection to any database/table that you have access to. Save the file and wait for index, it will index the filename but never its content.

With the WDS 2.6.5 this problem doenst happen.

Regards,

Marcus




Answer this question

WDS 3 - RTW Final not indexing .xlsx file which have ODBC SQL Connection

  • l33t

    Hi Marcus and Nathan,

    Can you send your files (.xlsx and .vb) to me if you don't have any confidential data in there please I can't seems to repro this with the 3.0 RTW build. See my profile for where to email it to.

    Thanks,

    David Peng (MSFT)


  • IsisTheDamned

    I'll add to this that other extensions appear to not get their contents indexed.

    It would be my .vb files that I'm specifically referring to. I went so far as to make sure the path was included, that the folder's properties has it allowed to be indexed, and also checked WDS File Types and set that file type and others to have it's contents indexed.

    I tried searching for a phrase and thought maybe it wouldn't cut it because it had a period or underscore, but I went ahead and chose something unique like the namespace which was all characters and no files were found.

    Nathan


  • Simple Samples

    Marcus,

    Ack! - this problem was reported while we were in beta. A bug was filed (and fixed) in a pre-release build. It must have broken again in a later build and made its way to RTW.

    Thanks for your feedback. I'll re-open the bug to make sure it is addressed in our next version (or a fix if one is deemed necessary).

    Paul Nystrom - MSFT



  • AamirHabib

    Thanks Paul,

    FYI, This bug is also present in the latest Vista version, RC2.

    Regards,

    Marcus



  • Ted.

    Hello Paul,

    Can you give us an update on this bug Should we expect a new version soon

    Thanks,

    Marcus



  • 3Nu

    Dear Daniel, Thanks for looking into this problem, it has been very difficult not to be able to search within those files.
    I have emailed you the .xlsx file, Few comments:
    1) The bug only presented itself for big files >700Kbytes or >8000 lines
    2) The bug happens when trying to search long numbers like 111111111, 2345544443, etc...
    3) This file is an ODBC SQL connection for a mysqlserver 2005.
    4) This problem happens both in WDS 3, as well as in Vista RTM.
    Hope this helps please let me know if you need further info.
    Best regards,
    Marcus Rodrigues


  • russ_mac

    Hello Anyone

  • WDS 3 - RTW Final not indexing .xlsx file which have ODBC SQL Connection