Invalid locale ID

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bobby Henningsen - 25 Jan 2006 10:19 GMT

Getting the following error in SQL 2005 :

Msg 7696, Level 16, State 10, Line 1
Invalid locale ID was specified. Please verify that the locale ID is correct
and corresponding language resource has been installed.

Well my question is : Is it possible to install a language or do I have to
accept the languages installed. My desired language is danish (locale id
1030) and it is not installed. I can see this by querying
sys.fulltext_languages. Well if it's not possible to install the language
then it is quite useless because I want to use the rules for the danish
language not sweduisk, english or german. It's not a new feature for me when
it is possible to choose language using Contains and Freetext if my desired
language isn't there. But here is the funny part. The language was present
in the Beta Version. What has happened ? Is Denmark wiped of the map since
then ????

Anybody knows ?

If it's not possible then let me know because then I can't use fulltext in
2005 either.

Regards :)
Bobby Henningsen

Reply to this Message

Daniel Crichton - 25 Jan 2006 11:57 GMT

Bobby wrote on Wed, 25 Jan 2006 11:19:30 +0100:

> Getting the following error in SQL 2005 :
>
[quoted text clipped - 17 lines]
> If it's not possible then let me know because then I can't use fulltext in
> 2005 either.

http://support.microsoft.com/kb/908441/en-us

As of the Sept CTP version of SQL Server 2005 the Danish word breaker is not
installed, along with some other languages, as these are 3rd party supplied
and not from Microsoft. The above link has information on how to add the
missing languages to the CTP, which I guess should work on the final release
too. However, the actual entries needed to add to the registry are missing
for the Danish breaker, so you might need to contact MS to get them to
update this article. There is a danlr.dll in the Binn dir in SQL Server 2005
(at least on my server there is), so it looks like the file ships with SQL
Server 2005, it just doesn't get enabled.

Dan

Reply to this Message

Bobby Henningsen - 25 Jan 2006 12:50 GMT

Hi Dan,
thanx a bunch. It works fine. Well had to restart the machine (hmm maby
reatrting the services would do but my VPC kind of "died"). But following
the article worked just fine. So now I'm much much happier :) So we can
conclude that it works in RTM. The dll's are there.

Regards :)
Bobby Henningsen

> Bobby wrote on Wed, 25 Jan 2006 11:19:30 +0100:
>
[quoted text clipped - 36 lines]
>
> Dan

Reply to this Message