?
Solved

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

Posted on 2008-06-19
5
Medium Priority
?
445 Views
Last Modified: 2012-06-22
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
Comment
Question by:pete5950
  • 3
  • 2
5 Comments
 
LVL 71

Expert Comment

by:Éric Moreau
ID: 21824240
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
 

Author Comment

by:pete5950
ID: 21824587
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
 
LVL 71

Expert Comment

by:Éric Moreau
ID: 21824620
it worked for me
0
 

Author Comment

by:pete5950
ID: 21825209
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
 

Accepted Solution

by:
pete5950 earned 0 total points
ID: 21876929
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

593 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question