If you are using SQL，You should use SqlConnection,SqlCommand in the System.Data.SqlClient；otherwises if access，you can use OleDb。But as far as I see，I don't think there's a FreeText search in the Access db。
PS：Try to have a test in the sql management studio to test your sql statement to see what's happening——make sure that there's no errors……
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: indexing service getting error Invalid catalog name 'MyCatlog'. SQLSTATE=42000
Jan 19, 2012 12:12 AM|LINK
Hello：）
If you are using SQL，You should use SqlConnection,SqlCommand in the System.Data.SqlClient；otherwises if access，you can use OleDb。But as far as I see，I don't think there's a FreeText search in the Access db。
PS：Try to have a test in the sql management studio to test your sql statement to see what's happening——make sure that there's no errors……
Reguards！