Tuesday, August 21, 2012 10:43 AM
We are having an issue querying a Full Text field under a SQL 2005 database.
We have a stored procedure that receives 4 parameters. One of them queries the database using full text, the other 3, LIKE. When we use only the LIKE parameters, or combine LIKE and FT parameters, everything goes fine. If we use only the FT parameter, it always cause an error 2.
Does anyone have any idea on why this could be happening, and what we could do to avoid it?
Our app is a ASP.NET one.
Thanks in advance for any help.
http://www.eopreco.com.br - Price Comparison. Need the lowest price? We find it for you.
Wednesday, August 22, 2012 9:12 AMModerator
Could you post the error message and your stored procedures?
Based on your description, it may be a connection problem, please follow this kb article:
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Wednesday, August 22, 2012 2:14 PM
Perhaps a silly question, but: Does the SQL Server service account have full control of the the folder where the full-text catalog is created?
I just ask since Error 2 is often something like 'cannot find the file'.