Link to home
Start Free TrialLog in
Avatar of pete5950
pete5950

asked on

PDF ifilter installed for full Text Search but search returns empty in SQL 2005 FTS

Just installed the PDF ifilter in SQL 2005 and created Full Text indexes for several comumns on a table. One of the columns contains pdf documents and is data type image. the others are nvarchar . Sull text searches return correctly on the nvarchar fields but the field containing the PDF document returns empty.

I ran the exe install from ADobe and manually registered the PDF filter. any suggestions would be greatly appreciated.
Thanks!
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

As per http://support.microsoft.com/default.aspx?scid=kb;en-us;945934 
3.      In SQL Server Management Studio, select the instance in which you want to enable IFilters, and then run the following command in that instance:
sp_fulltext_service 'load_os_resources', 1
4.      If you are running SQL Server 2008, go to Step 5. If you are running SQL Server 2005, stop and restart the msftesql service. To do this, follow these steps:
a.       At a command prompt, type the following command and then press Enter:
net stop msftesql
Note To stop the msftesql service for a specific instance, run the following command:
net stop msftesql$InstanceName
b.       At a command prompt, type the following command and then press Enter:
net start msftesql
Note To start the msftesql service for a specific instance, run the following command:
net start msftesql$InstanceName

5.      Restart the SQL Server service.

Avatar of pete5950
pete5950

ASKER

I did these things and have the same result. The query I am running is in Query Analyzer:

SELECT * FROM ContainsTable([editionArticle], pdf, '"Sale"') and returns empty.

a similar query run agains a nvarchar field "SELECT * FROM ContainsTable([editionArticle], Title, '"Supertest2"')" returns the Primary key and a rank.
it worked for me
Thanks emoreau, I wish it had worked for me. There is probobly something stupid and simple that I am missing. I do appreciate the input. THANKS :-)
ASKER CERTIFIED SOLUTION
Avatar of pete5950
pete5950

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial