Fulltext search returns Null
Heinz-Dieter Janzen
I can't get fulltext to run - the following statement returns Null:
SELECT FT_Text FROM dbo.FTTestTable WHERE CONTAINS(FT_Text, 'zweite')
These are some details:
Windows XP SP3
Microsoft Server 2008 Express
Microsoft SQL Server Management Studio 10.0.2531.0
Microsoft Data Access Components (MDAC) 3.85.1132
Microsoft MSXML 2.6 3.0 5.0 6.0
Microsoft Internet Explorer 8.0.6001.18702
Microsoft .NET Framework 2.0.50727.3603
Operating System 5.1.2600
SQL Full Text Filter Daemon Launcher' is started and running
Column FT_Text is nvarchar(50), Null not allowed
Full Text Catalogs and Full Text Stoplist exist
SELECT DATABASEPROPERTY('HDJTest', 'IsFullTextEnabled') gives 1
SELECT FULLTEXTSERVICEPROPERTY('IsFullTextInstalled') gives 1
But: Database "FullTextTest" / Manage FullText Catalogs" returns:
Unhandled exception has occured in a component in your application.
If you click continue, the application will ignore this error and
attempt to continue.
Unable to cast object of type "System.DBNull" to type "System string"
The first lines of the exception report say:
System.InvalidCastException: Unable to cast object of type 'System.DBNull'
to type
'System.String' at
iucon.ssms.ExpressFulltext.Data.FulltextDataSet.fulltext_catalogsRow.get_path()
Googling for "iucon.ssms" gives the following link, where the same problem
is
described - without solution!
http://fulltextmanager.codeplex.com/workitem/7795
In this link you find as well the complete destail text.
Somebody can help?
Dieter