1 Reply Latest reply on Jun 29, 2009 1:42 PM by Ifilterv9

    Help!- problems with Adobe reader v9 ifilter and sqlserver2005

    Ifilterv9

      Hello,

       

      I am trying to implement search of pdf in binary column in sqlserver2005 using Adobe ifilter.

      I installed full version of Adobe reader v9 which has its own Ifilter on my server (runs on 32bit)

      I have done the following based on what i read on the internet:

       

      • The environment variable path has an entry for Adobe reader the following:D:\Program Files\Adobe\Reader 9.0\Reader
      • exec sp_fulltext_service 'load_os_resources', 1;
      • exec sp_fulltext_service 'verify_signature', 0;
      • Restarted services SQLserver and MSFTESQL

       

      The issue is upon installation, sqlserver wasn't showing the doc type 'pdf' so I registered the dll but the sys.fulltext_document_type is showing this path instead and I can't update system tables in sqlserver2005.

       

      Also when I carry out a search based on my Fulltext setup, it returns 0 rows.

       

       

       

      select

       

       

       

       

       

       

       

      document_type, path from sys.fulltext_document_types where document_type = '.pdf'

       

       

       

      document_type               Path

      ------------------------------------------------------------------------------------------ --------------------------------------------------------

      .pdf                                c:\program Files\Microsoft SQL Server\MSSQL.3\MSSQL\Binn\AcrodIF.dll

       

       

       

      Please what can I do to correct things and make it possible to carry out my pdf search

      THANKS!!!!

        • 1. Re: Help!- problems with Adobe reader v9 ifilter and sqlserver2005
          Ifilterv9 Level 1

           

          I have resolved this myself as follows:

           

          • I deleted the pdf document type entry from table sys.fulltext_document_types
          • At the command prompt, in the directory where Acrobat reader is installed which was on my server D drive path:

                 d:\program Files\Microsoft SQL Server\MSSQL.3\MSSQL\Binn\ and REGISTERED the ifilter dll - AcrodIF.dll

           

          • exec sp_fulltext_service 'load_os_resources', 1;
          • exec sp_fulltext_service 'verify_signature', 0;
          • Restarted MSFTESQL service
          •   This resolved the problem and all these searches work:

            • select * from tablename where freetext(*, 'searchword')
            • select * from tablename where contains(*, 'searchword')

            Search phase also work:

            • select * from tablename where freetext(*, '*search phrase*')
            • select * from tablename where contains(*, '*search phrase*')