This is an explanation of the error:
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
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).
Okay, i have checked our knowledgebase which bought back many cases with
similar issues. Things to check -
- Check that INFORMIXDIR and PATH have been set correctly.
- Check where the I-Connect has been installed i.e in program files, separate
Informix dir, etc etc. Really, it should be installed (using custom
installation) under c:\informixdir as I-Connect sometimes complains about being
installed under program files..Please don't forget to uninstall any previous
versions before installing.
- Check Locales CLIENT_LOCALE=
- in database : en_us.8859-1
- in client: en_US.CP1252