Locale Problem, Please Help!

[mbaranski]

I'm using Informix version 9, with the newest csdk on AIX, and I get the following error when my client (a c program compiled with esql) tries to connect to the database:

[root@p140 bin]# ./finderr -23101
-23101 Unable to load locale categories.

An invalid locale name was supplied for the locale initialization.
The environment variable to specify the locale category has a wrong
value. Check the value of the corresponding environment variable,
CLIENT_LOCALE or DB_LOCALE. Also check if INFORMIXDIR points to a valid
directory where Informix products are installed.

If a client application receives this error when it requests a database
server connection, check that the client and database locales are
compatible. They are compatible if a valid locale exists on the server
computer with the name lg_tr.codeset@mod, where lg_tr (language and
territory) and mod (locale modifier) are from the CLIENT_LOCALE and
codeset is from the database locale (from the DB_LOCALE, if it is set,
or as stored in the database).

Could one of the Informix gurus here please translate this for me? How do I go about finding out what to set the 2 environment vars to? I'm stumped by a frustratingly simple problem. As always, I hope that helped!

Disclaimer:
Beware: Studies have shown that research causes cancer in lab rats.

 

[richman]

Hi,
I am still in the world of version 7.xx so I'll venture a guess or more . . .
Primarliy the error message has one hint -

"Also check if INFORMIXDIR points to a valid
directory where Informix products are installed."


If you haven't already done this . . .Check the exported values for
$INFORMIXSERVER
$ONCONFIG
and make sure they point to valid paths/files

Also, version 7.x has a path $INFORMIXDIR/gls that has language specific files (e.g., for English there is a subdirectory of en_us that has language files for English). I believe that this is considered part of the 'locale' information.

If all else fails Informix support has been pretty good to me.
Rich