using Full Text Search in SQL Server 2008 which is on a Windows Server 2008 R2 64 bit machine

• SJanki

  SSCrazy

  Points: 2847

  More actions

  July 31, 2011 at 7:03 pm

  #245373

  Hi,

  I have to implement Full Text Search.

  I have the binary data of the PDF files in a table.

  In development environment I have SQL Server 2005/Windows Server 2003. I downloaded the PDFFilter dll from Adobe and the search works very fine.

  For the production environment which is SQL Server 2008/Windows Server 2008 R2 64 bit, the above did not work and looking into some of the websites I downloaded the PDFFilter dll for 64 bit from Adobe site.

  But still Full Text Search is not working. There is no error, it simply does not return any results.

  My another question is about updating the sys.fulltext_document_types system view.

  I read in a site, to actually download the PDFFilter in System32 folder instead of the default path so I again un-installed and installed the dll ,this time giving the path as Windows/system32.

  But I have to update the pdf row in the sys.fulltext_document_types view to point it to the correct path of the dll.

  But SQL Server is not allowing me to delete any row from this view or update it. It gives some error like Catalog can not be updated.

  I am not sure what is the underlying table for this view.

  Do I need to find that table and delete the row from there?

  Thanks - Janki

• SJanki

  SSCrazy

  Points: 2847

  More actions

  August 1, 2011 at 10:43 am

  #1361697

  Installed PDFFilter for 64 bit again and this time after rebooting the server the path showed correctly in sys.fulltext_document_types, system view.

  (C:/windows/system32/bin/pdffilter.dll)

  But the search returns nothing.

  Please share your solutions if anyone has faced similar issue with PDFFilter.dll

  Thanks ~ Janki

• SJanki

  SSCrazy

  Points: 2847

  More actions

  August 1, 2011 at 1:31 pm

  #1361812

  Finally............................................... It started working.

  I did couple of things like setting the System-->Path variable,

  Rebuilding the catalog, Indexing options ....

  uninstalling, re-installing the PDFFilter.dll

  and rebooted the server several times!

  Not sure what triggered the Full Text Search on PDF to work!!!!

  Thanks to all the sites that really helped.