|
 |
asptoday_discuss thread: SQL Server - Full Text Index problem
Message #1 by "Michael Bell" <michaeljbell@b...> on Mon, 5 Aug 2002 09:10:19
|
|
Hi,
Running Win 2000 server platform with SQL server 2000 installed.
Have successfully implemented a full text search on one of the databases
running on this server.
However when I have tried to implement a similar search on a different
database running on this server, I get the following error message when
attempting to query an indexed table.
Langauge database/cache file could not be found.
Can anyone help?
Thanks,
Michael
Message #2 by "Mark Phillips" <webmaster@d...> on Mon, 5 Aug 2002 09:09:42 +0100
|
|
This is a little vague, but I seem to remember having this one before. Check
the Regional Settings on the machine match the language used in MS SQL...
-----Original Message-----
From: Michael Bell [mailto:michaeljbell@b...]
Sent: 05 August 2002 09:10
To: ASPToday Discuss
Subject: [asptoday_discuss] SQL Server - Full Text Index problem
Hi,
Running Win 2000 server platform with SQL server 2000 installed.
Have successfully implemented a full text search on one of the databases
running on this server.
However when I have tried to implement a similar search on a different
database running on this server, I get the following error message when
attempting to query an indexed table.
Langauge database/cache file could not be found.
Can anyone help?
Thanks,
Michael
Message #3 by "Michael Bell" <michaeljbell@b...> on Mon, 5 Aug 2002 13:27:26
|
|
Thanks for that. To give you more information, the Regional Settings on
the Server itself in Windows is English (United Kingdom), the language in
SQL Server (checked through enterprise manager) states English (United
States).
However, the full text search for one of the datbases running off the
server works fine. A similar search implemented in exactly the same way on
a second db gives the error:
Langauge database/cache file could not be found.
How can this be. To give more information this search used to work OK but
I recently rebooted the server and now I get the error.
I got this info from the MS site:
----------------------------------
If one or more of the default language files Wbdbase. and Wbcache. is
absent, copy the files from the Exchange 2000 computer installation source
to the System32 folder. For example, copy the German Germany default
language files Wbdbase.deu and Wbcache.deu from the Exchange 2000 computer
installation source to the System32 folder.
--------------------------------------------
This is for the same error msg but relating to mailboxes, I read on
another forum that following this may resolve the problem. On checking the
server neither the Wbdbase.eng (UK format) or Wbcache.eng were present.
Just getting confused as to where these might have gone and how one
database's full text works and another one doesn't.
Thanks,
Michael
> This is a little vague, but I seem to remember having this one before.
Check
the Regional Settings on the machine match the language used in MS SQL...
-----Original Message-----
From: Michael Bell [mailto:michaeljbell@b...]
Sent: 05 August 2002 09:10
To: ASPToday Discuss
Subject: [asptoday_discuss] SQL Server - Full Text Index problem
Hi,
Running Win 2000 server platform with SQL server 2000 installed.
Have successfully implemented a full text search on one of the databases
running on this server.
However when I have tried to implement a similar search on a different
database running on this server, I get the following error message when
attempting to query an indexed table.
Langauge database/cache file could not be found.
Can anyone help?
Thanks,
Michael
Message #4 by "Mark Phillips" <webmaster@d...> on Tue, 6 Aug 2002 12:08:54 +0100
|
|
It was some time ago, so I don't recall all the details. I do remember it
was a problem that confused the hell out of us for some time and we found an
article at support.microsoft.com which explained what the issue was and we
were then able to resolve it quickly.
I guess it's possible that if you copy or export a database / its objects
from one server to another, and the other server has different settings, you
then hit the problem again?
-----Original Message-----
From: Michael Bell [mailto:michaeljbell@b...]
Sent: 05 August 2002 13:27
To: ASPToday Discuss
Subject: [asptoday_discuss] RE: SQL Server - Full Text Index problem
Thanks for that. To give you more information, the Regional Settings on
the Server itself in Windows is English (United Kingdom), the language in
SQL Server (checked through enterprise manager) states English (United
States).
However, the full text search for one of the datbases running off the
server works fine. A similar search implemented in exactly the same way on
a second db gives the error:
Langauge database/cache file could not be found.
How can this be. To give more information this search used to work OK but
I recently rebooted the server and now I get the error.
I got this info from the MS site:
----------------------------------
If one or more of the default language files Wbdbase. and Wbcache. is
absent, copy the files from the Exchange 2000 computer installation source
to the System32 folder. For example, copy the German Germany default
language files Wbdbase.deu and Wbcache.deu from the Exchange 2000 computer
installation source to the System32 folder.
--------------------------------------------
This is for the same error msg but relating to mailboxes, I read on
another forum that following this may resolve the problem. On checking the
server neither the Wbdbase.eng (UK format) or Wbcache.eng were present.
Just getting confused as to where these might have gone and how one
database's full text works and another one doesn't.
Thanks,
Michael
> This is a little vague, but I seem to remember having this one before.
Check
the Regional Settings on the machine match the language used in MS SQL...
-----Original Message-----
From: Michael Bell [mailto:michaeljbell@b...]
Sent: 05 August 2002 09:10
To: ASPToday Discuss
Subject: [asptoday_discuss] SQL Server - Full Text Index problem
Hi,
Running Win 2000 server platform with SQL server 2000 installed.
Have successfully implemented a full text search on one of the databases
running on this server.
However when I have tried to implement a similar search on a different
database running on this server, I get the following error message when
attempting to query an indexed table.
Langauge database/cache file could not be found.
Can anyone help?
Thanks,
Michael
Message #5 by "Michael Bell" <michaeljbell@b...> on Tue, 6 Aug 2002 15:17:07
|
|
Hi
OK, have managed to solve this one. Just set language for word-breaker to
neutral when defining full text indexing on that table.
Don't know how it used to work in the past as it was not set up like this.
Thanks for all your help.
Michael
> It was some time ago, so I don't recall all the details. I do remember it
was a problem that confused the hell out of us for some time and we found
an
article at support.microsoft.com which explained what the issue was and we
were then able to resolve it quickly.
I guess it's possible that if you copy or export a database / its objects
from one server to another, and the other server has different settings,
you
then hit the problem again?
-----Original Message-----
From: Michael Bell [mailto:michaeljbell@b...]
Sent: 05 August 2002 13:27
To: ASPToday Discuss
Subject: [asptoday_discuss] RE: SQL Server - Full Text Index problem
Thanks for that. To give you more information, the Regional Settings on
the Server itself in Windows is English (United Kingdom), the language in
SQL Server (checked through enterprise manager) states English (United
States).
However, the full text search for one of the datbases running off the
server works fine. A similar search implemented in exactly the same way on
a second db gives the error:
Langauge database/cache file could not be found.
How can this be. To give more information this search used to work OK but
I recently rebooted the server and now I get the error.
I got this info from the MS site:
----------------------------------
If one or more of the default language files Wbdbase. and Wbcache. is
absent, copy the files from the Exchange 2000 computer installation source
to the System32 folder. For example, copy the German Germany default
language files Wbdbase.deu and Wbcache.deu from the Exchange 2000 computer
installation source to the System32 folder.
--------------------------------------------
This is for the same error msg but relating to mailboxes, I read on
another forum that following this may resolve the problem. On checking the
server neither the Wbdbase.eng (UK format) or Wbcache.eng were present.
Just getting confused as to where these might have gone and how one
database's full text works and another one doesn't.
Thanks,
Michael
> This is a little vague, but I seem to remember having this one before.
Check
the Regional Settings on the machine match the language used in MS SQL...
-----Original Message-----
From: Michael Bell [mailto:michaeljbell@b...]
Sent: 05 August 2002 09:10
To: ASPToday Discuss
Subject: [asptoday_discuss] SQL Server - Full Text Index problem
Hi,
Running Win 2000 server platform with SQL server 2000 installed.
Have successfully implemented a full text search on one of the databases
running on this server.
However when I have tried to implement a similar search on a different
database running on this server, I get the following error message when
attempting to query an indexed table.
Langauge database/cache file could not be found.
Can anyone help?
Thanks,
Michael
|
|
|
View Cart
