Unanswered: ODBC 'Test connection was NOT successful'
I have a problem with the ODBC driver version 3.81 32 bit
when I want to connect with the DB in the server. I get this message 'Test connection was NOT successful.[Informix][Informix ODBC Driver][Informix]Unable to load locale categories.'
I don't see any immediate issues with these versions.
Are you sure the ilogin demo works and is able to connect without displaying any error?
You could always set ODBC tracing on. Just to see what error is returned.
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