help needed for fulltext error

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
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
>
>
|||thanks john
the hosting providers are now having a look from their end so i will post
the data in a few days if they cant fix it
bob
"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[vbcol=seagreen]
> 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...
'"adelaide"')[vbcol=seagreen]
not[vbcol=seagreen]
> be
full
>