Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Full-Text Search / June 2007

Tip: Looking for answers? Try searching our database.

Cannot Create Full-Text Catalog

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ross Culver - 13 Jun 2007 14:30 GMT
I had a perfectly good FT catalog, but I was trying to repopulate it after
making changes to the noiseeng file.  I restarted the Full-Text search
engine.

When I tried to run a full-text query against the table, I got this error
"no such interface supported".  In the message there was a recommendation to
create a new catalog.

I decided to delete the existing catalog, but now cannot create a new one.
I get the following full message:

TITLE: Microsoft SQL Server Management Studio
Cannot execute changes.
Create failed for FullTextCatalog 'FTCDoctors'.  (Microsoft.SqlServer.Smo)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.0
0&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationEx
ceptionText&EvtID=Create+FullTextCatalog&LinkId=20476

------------------------------
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
------------------------------
Execution of a full-text operation failed. 'No such interface supported'
(Microsoft SQL Server, Error: 7689)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3054&
EvtSrc=MSSQLServer&EvtID=7689&LinkId=20476


The links are dead links now.  Figures.

Can anyone help me?

Thanks, Ross
Ross Culver - 13 Jun 2007 14:36 GMT
Unable to find a cure, I uninstalled the Full-Text engine, rebooted,
reinstalled Full-Text, rebooted and was able to rebuild the catalog and
index.  But I'd sure like to know what happened and what this error really
means.

Ross

>I had a perfectly good FT catalog, but I was trying to repopulate it after
> making changes to the noiseeng file.  I restarted the Full-Text search
[quoted text clipped - 27 lines]
>
> Thanks, Ross
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.