Question & Answer
Question
How do you install a 64 bit Adobe PDF iFilter for SQL Server when using Windows Server 2012, to enable iBase Search 360 to index PDF documents?
Cause
In order for iBase Search 360 to successfully index a PDF document in the database, an appropriate Adobe PDF iFilter must be installed.
Windows Server 2012 requires that a 64 bit iFilter be installed. IBM i2 iBase only supports Adobe iFilter versions up to 9. Version X (10) and XI (11) Adobe iFilters are not supported.
Answer
Before installing a new Adobe iFilter, ensure you have removed any previous versions. Instructions for removing iFIlters can be found in the following article: http://www.ibm.com/support/docview.wss?uid=swg21883549
1. Download and install the 64 bit version 9 iFilter from Adobe's FTP site: ftp://ftp.adobe.com/pub/adobe/acrobat/win/9.x/PDFiFilter64installer.zip
2. Run the following query in SQL to update the list of installed iFilters:
Exec sp_fulltext_service 'load_os_resources', 1
Exec sp_fulltext_service 'verify_signature', 0
3. Restart the SQL Server & Full Text Search services
4. Run the following query to display installed PDF iFilters in SQL:
SELECT document_type, path from sys.fulltext_document_types where document_type = '.pdf'
If the iFilter has been successfully installed, the SQL query from 4. should display the following output:
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21883552