Hi,
here is my problem which I need to solve asap. I want to search in my file system (.htm files using index server) for both english and arabic, english search is working fine but not arabic. I try to execute it by using sql query pane in dnn and it fails but the same query execute successfully for both english and arabic in SQL Query Analyzer.
One more thing, English and Arabic search on database tables for fulltext search is working fine but not on file system. it drive me crazy. and dont know what to do. please help.
here is the error:
System.Data.SqlClient.SqlException: Cannot execute the query "SELECT Filename FROM SCOPE() WHERE FREETEXT('باستبدال عضوية')" against OLE DB provider "MSIDXS" for linked server "LEGALDBSERVER". OLE DB provider "MSIDXS" for linked server "LEGALDBSERVER" returned message "The query contained only ignored words. ". at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) SELECT Docs.FileName FROM OPENQUERY(LEGALDBSERVER, 'SELECT Filename FROM SCOPE() WHERE FREETEXT(''باستبدال عضوية'')') AS Docs
My development environment:
DNN 4.5
SQL Server 2005
IIS 5
Thanks for any help.