Re: Invalid locale ID

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


.

Relevant Pages

  • Re: Full-Text Catalog does not build...
    ... You're welcome, Oleg, ... I've not confirmed if the Arabic language will be a FTS supported ... language in SQL Server 2005, you may want to review the ...
    (microsoft.public.sqlserver.fulltext)
  • Re: SQL
    ... Language can and do this. ... SQL is typed, ... How about something from the domain of custom biz apps. ... yet nobody would even try to use RDBMS for that. ...
    (comp.object)
  • Re: Databases as objects
    ... Isn't SQL able to assimilate to business vocabulary? ... using the same domain-ignorant language? ... Isn't the database schema already a domain-specific interface? ... have lesser lines of code than a corresponding assembler source code. ...
    (comp.object)
  • Re: SQL
    ... to have an ability to place things into cells ... It is a language issue then. ... An RDBMS engine that may ... Put a program code in a relational table and write compiler in SQL ...
    (comp.object)
  • Re: Full-Text Catalog does not build...
    ... You're welcome, Oleg, ... information as this is very useful in troubleshooting SQL FTS issues! ... language of US_English and with your column specific "Language for Word ... all of the *currently* supported languages in SQL Server 2005 for Full Text ...
    (microsoft.public.sqlserver.fulltext)
Loading