全文搜索不适用于MDF文件 [英] Full text Search not work with MDF file

问题描述

大家好，我有一个C＃.net桌面应用程序，完全完整，并且在使用直接连接数据库时运行良好，



现在我的问题是当我使用相同数据库的Mdf文件附加此应用程序时，我的项目的某些功能不起作用（如全文搜索，我用于在文本类型列索引）..



所以请帮助..

数据库大小为2.5 GB

我的查询赞这个

Hi All, I Have a C#.net Desktop Application, Which is fully complete,and work well when use with direct connection with Database,

Now my issue is When i attach this application with Mdf file of Same Database, then Some Feature of My project Not work(Like Full text Search,which i use for indexing at text type column)..

So please help..
Database Size is 2.5 GB
My Query Like This

SELECT....WHERE CONTAINS()

我得到的错误是这样的：

I Got Error Like This:

Cannot use full-text search in user instance

我的连接字符串是：

name =ITLconnectionstring =Data Source = .\SQLEXPRESS; AttachDbFilename = | DataDirectory | \ITL_Local.mdf; Integrated Security = True; User Instance = True

My Connection String is:
name="ITL" connectionstring="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ITL_Local.mdf;Integrated Security=True;User Instance=True

推荐答案

请参阅：不能在用户实例中使用全文搜索 [ ^ ]



只是不要使用用户实例。正常附加数据库。

See: Cannot use full-text search in user instance[^]

Simply don't use user instance. Attach the database normally.

Quote：

全文搜索不支持一个SQL Server Express用户实例。

Full text Search is not supported on a SQL Server Express user instance.

https://technet.microsoft.com/en-us/library/ms143684(v = sql.105）.aspx [ ^ ]

如错误所示，请不要不要使用用户实例。这不受支持。相反，使用普通的基于服务的实例并将数据库附加到该实例中。



用户实例的问题在于它们随程序一起启动和停止。基本上这消除了使用任何后台服务的可能性

As the error says, don't use a user instance. This is not supported. Instead, use a normal, service based instance and attach the database into that instance.

The problem with user instances is that they are started and stopped along with the program. Basically this eliminates the possibility to use any 'background services'

这篇关于全文搜索不适用于MDF文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！