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.'
Best regards

Can you edit the $INFORMIXDIR/etc/.snfile file, and check that the mandatory product installation order has been respected :

a) development tools
b) database engine
c) network tools

Hi

Typically, this error occurs when you don't have an INFORMIXDIR set in your setnet32 or as environment variable.

Emmon

i have this problem too .but i have set the INFORMIXDIR.In win2000 pro OS that was successful,and in win98 OS the connect was fail,the same configuration in this two OS.
why??

Hi, are you able to connect to the server with the ilogin demo, provided by informix from the win98 machine?

YES £¬I CAN use the Ilogin Demo connect to the sever,but ODBC CAN'T from the win98 machine

Can you tell me what the exact version is of the CSDK and of the ODBC driver?

CSDK VERSION:ibm informix client-sdk2.80
ODBC VERDION:3.520.4403.2(from ODBC ->ABOUT)

thanks!

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.

I sure the ilogin demo works and is able to connect without displaying any error

The odbc error message is :
Test connection was NOT successful,[informix][informix ODBC Driver] Unable to load translation DLL.
I have test ODBC in two win98 machines and the error message was same!

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
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).

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

YES,that's ok!

I MODIFY the "PATH=C:\PROGRAM FILES\INFORMIX\CLIENT-SDK\BIN " TO " PATH=C:\PROGRA~1\INFORMIX\CLIENT~1\BIN" IN AUTOEXEC.BAT ,THEN TEST SUCCESSFUL!


THANKS roelwe!!