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.

I figure out one more thing that the samel query works with CONTAINS() but not with FREETEXT().

If I FREETEXT() with CONTAINS() it works fine. But definitely I need to search for all word so I need to use FREETEXT().

sorry, I do not use Arab in my databases.

Please be aware, that SQL Query Analyzer might act different than data access via .Net DAAB.