"bob" <stirling@picknowl.com.au> wrote in message
news:u$XEHCtPEHA.252@TK2MSFTNGP10.phx.gbl...
> hello,
>
> i have been executing the following statement
>
> SELECT title FROM searchtable1 WHERE CONTAINS (filecontent, '"adelaide"')
>
> (which works ok on the development box)
>
> and receiving the following error (on the live site)
>
> Microsoft OLE DB Provider for SQL Server error '80040e14'
>
> Execution of a full-text operation failed. The specified module could not
be
> found.
>
> the version is sql-server with sp3 applied....I have had to build the full
> text catalogue
> by executing stored procedures through asp pages.
>
> has anyone got any ideas on this one??
>
> regards
>
> patrick
>
>
>

"John Kane" <jt-kane@comcast.net> wrote in message
news:uqNYiKtPEHA.1340@TK2MSFTNGP12.phx.gbl...
> Bob,
> The OLE DB Provider error message is not enough info to go on. However,
I've
> seen the message text (The specified module could not be found.) before as
> the message text is related to ERROR_MOD_NOT_FOUND. When you installed
SQL
> Server 2000 or applied a Service Pack were there any reported errors or
> problems? Check or post the following files: SearchSetup.log and
sqlstp.log
> on your problem SQL Server 2000 server. Furthermore, please post the full
> output of the following SQL code:
>
> use master
> go
> SELECT @@language
> SELECT @@version
> exec sp_configure 'default full-text language'
> go
> use <your_database_name>
> go
>
> EXEC sp_help_fulltext_catalogs
> EXEC sp_help_fulltext_tables
> EXEC sp_help_fulltext_columns
> go
>
> Regards,
> john
>
>
> "bob" <stirling@picknowl.com.au> wrote in message
> news:u$XEHCtPEHA.252@TK2MSFTNGP10.phx.gbl...
> > hello,
> >
> > i have been executing the following statement
> >
> > SELECT title FROM searchtable1 WHERE CONTAINS (filecontent,
'"adelaide"')
> >
> > (which works ok on the development box)
> >
> > and receiving the following error (on the live site)
> >
> > Microsoft OLE DB Provider for SQL Server error '80040e14'
> >
> > Execution of a full-text operation failed. The specified module could
not
> be
> > found.
> >
> > the version is sql-server with sp3 applied....I have had to build the
full
> > text catalogue
> > by executing stored procedures through asp pages.
> >
> > has anyone got any ideas on this one??
> >
> > regards
> >
> > patrick
> >
> >
> >
>
>