Geek Answers Handbook

SQL Server PDF full text search does not work with FileStream PDF file

I cannot get a full-text search for working with PDF files. I upload my SQL Db via FileStream.

Version: SQL Server 2008 R2 (Developer Edition - proof of concept) OS: Windows 7

The steps that I have taken.

  • Adobe iFilter Installed
  • Verify that the SQL Server Full Text Server service is running
  • Added environment path to Adobe PDF Filter bin directory

  • Cancel the scripts below to configure the new iFilter and make sure it is active

    EXEC sp_fulltext_service @action='load_os_resources', @value=1; -- update os resources EXEC sp_fulltext_service 'verify_signature', 0 -- don't verify signatures EXEC sp_fulltext_service 'update_languages'; -- update language list EXEC sp_fulltext_service 'restart_all_fdhosts'; -- restart daemon EXEC sp_help_fulltext_system_components 'filter'; -- view active filters

  • Created a full-text index on a FileStream table that I would like to index

     CREATE FULLTEXT INDEX on local.FILE_REPOSITORY (DOCUMENT TYPE COLUMN FILE_EXTENSION) Key Index PK_File_Repository ON (FileSearchCat, FILEGROUP [PRIMARY]); GO

  • Restored Directory

     ALTER FULLTEXT CATALOG FileSearchCatREBUILD WITH ACCENT_SENSITIVITY=OFF;

  • Query to see if the index works

     select * from local.FILE_REPOSITORYwhere freetext(DOCUMENT, '25678')

Doesn't return any results for a PDF, but works fine for a word (docx)?

What am I doing wrong?

+7
source share
1 answer

Ok, so I realized that I needed to follow these steps:

 EXEC sp_fulltext_service @action='load_os_resources', @value=1; -- update os resources EXEC sp_fulltext_service 'verify_signature', 0 -- don't verify signatures EXEC sp_fulltext_service 'update_languages'; -- update language list EXEC sp_fulltext_service 'restart_all_fdhosts'; -- restart daemon EXEC sp_help_fulltext_system_components 'filter'; -- view active filters

But you also need to run this !!!!

 reconfigure with override
+3
source

More articles:


All Articles