Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 441
  • 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

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

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