Click here to Skip to main content
15,911,142 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)
See more:
I have a problem with my sql server 2005.
I installed sql server 2005 Advanced service before implementing Fulltext search application.
Now in my application when i checked if Fulltextservice is installed on the server it return true,
but when i want to access the database fulltextcatalogs the application throws this exception:
"Full-text is not supported on this edition of SQL Server."

Although I implemented fulltext search and it works perfectly when i performed search in the application.
I wondering why the line throws exception.
I spent 2 days on this without finding solution.
this is my source code:

srv = new Server(_instancename)

if (srv.IsFullTextInstalled == true)//this line return true
{
 Database db = srv.Databases["jorce"];
 if (! db.FullTextCatalogs.Contains("JorceFTCat"))//this line throws exception: "Full-text is not supported on this edition of SQL Server."
 {
 FullTextCatalog ftc = new FullTextCatalog(db, "JorceFTCat");
 ftc.IsDefault = true;
 ftc.Create();
 }
}


I'm confused.
Thanks for the help.
Posted
Updated 14-Apr-11 15:18pm
v2

1 solution

Download the latest Cumulative Update of Sql Server 2008.

Or follow this link[^] for the discussion.
 
Share this answer
 
Comments
mouss2006 15-Apr-11 15:05pm    
Thank s Pong D.Panda

But I want to use sql server 2005 advanced service (i desinstalled sql server 2005 for the advanced edition).

It works perfectly when i create the FullTextCatalog and Fulltextindex.
All the sripts i executed in sql server management studio work fine.

Now I have finished to developp the application. And now for installing this application
on the client machine, i wrote a script using SMO in c# language but i don't know why it said
that fulltextservice is not supported. Athough it exists.

Thanks for you help.
mouss2006 15-Apr-11 15:14pm    
When startin with sql server 2005 it was said thaht this version donot support fulltext but the 2005 advanced service version support the feature.
And it does coorectly. Icreate catalog with the advanced version using studio management.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900