• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 446
  • Last Modified:

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!
0
pete5950
Asked:
pete5950
  • 3
  • 2
1 Solution
 
Éric MoreauSenior .Net ConsultantCommented:
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.

0
 
pete5950Author Commented:
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.
0
 
Éric MoreauSenior .Net ConsultantCommented:
it worked for me
0
 
pete5950Author Commented:
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 :-)
0
 
pete5950Author Commented:
After looking at all of the variables several times, and following the advice here , at Microsoft and a few other locations and trying it on two different servers without results, I changed the data type on the column storing the PDFs from image to varbinary and it began working immediately.
It is fast an solid and a truely marvelous thing.
Thanks for your help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now