2012年3月22日星期四

Full Text Search & Visual Studio 2005

Hello, I have a database that has Full Text Search it works great under Management Studio Express. I can use the CONTAINS expression no problem.

Now when I try using the same database in Visual Studio 2005 the CONTAINS statement it doesn't return any values and I don't get any error messages.

The way I call my database from my web.config file is as follows:

<add name="MyDB" connectionString="Data Source=.\FULLTEXTSEARCH;Integrated Security=True;AttachDBFilename='D:\My Documents\Visual Studio 2005\WebSites\App_Data\MyDataBase.mdf';User Instance=false" providerName="System.Data.SqlClient"/
Why doesn't Full Text Search work when I use it from my web application and it does work under SQL Server Management Studio Express?

Please help,

Louis

Me again, I do get an error message when I try to run a query in Visual Studio 2005, namely:

Full-Text Search is not installed, or a full-text component cannot be loaded.

But it works just fine in Management Studio Express.

|||

I figured out my on problem. I was running the wrong database, my bad.


没有评论:

发表评论