Invalid locale ID

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
Bobby wrote on Wed, 25 Jan 2006 11:19:30 +0100:

> 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.
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
|||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
"Daniel Crichton" <msnews@.worldofspack.co.uk> skrev i en meddelelse
news:uY410ZaIGHA.3120@.TK2MSFTNGP10.phx.gbl...
> Bobby wrote on Wed, 25 Jan 2006 11:19:30 +0100:
>
> 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
>