Hi all,

I'm running IDS on RHL 9.
I wrote the following simple EC program:

int main (argc, argv)
int argc;
char *argv[];
{
printf ("Start\n");
EXEC SQL connect to "mydb";
printf ("<%d>\n", SQLCODE);
}

When I run this program, I get the error:
-23101: Unable to load locale categories
I can access mydb through dbaccess, but I cannot connect using this program.

* INFORMIXDIR and INFORMIXSERVER are correctly point to the Informix directory and server respectively.

* LD_LIBRARY_PATH is pointing to $INFORMIXDIR/lib and $INFORMIXDIR/lib/esql
* PATH does point to $INFORMIXDIR/bin.

* DB_LOCALE, CLIENT_LOCALE, SERVER_LOCALE and DBLANG are all set to blank (unset). In this case, en_us.8859-1 is the default.

* When I run the Linux shell command 'locale', I get the following:
LANG=en_US.UTF-8
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=

* I tried to set the 4 environment variables above (DB_LOCALE, CLIENT_LOCALE, SERVER_LOCALE and DBLANG) to en_us.8859-1, en_US.UTF-8, (blank), en_us.ISO8859-1, en_us.cp1252, but nothing seemed to help.

Any clue to what I can do to get this fixed?

Thanks,
RH

Hello rmhaddad,
Have you find the solution for the described problem 5 years ago ?

At the moment I have almost same problem:
I'm trying to use Informix ESQL/C compiler on Linux x64.

I have researched many different forums on the internet
in order to find solution but it seems like nobody
had any answer.

The situation I have:

I try to compile my .ec program using following command:
esql -e myprogram.ec

and have got an error message:
-23101 Unable to load locale categories

Output of locale command on my host is:

LANG=en_US.iso885915
LC_CTYPE="en_US.iso885915"
LC_NUMERIC="en_US.iso885915"
LC_TIME="en_US.iso885915"
LC_COLLATE="en_US.iso885915"
LC_MONETARY="en_US.iso885915"
LC_MESSAGES="en_US.iso885915"
LC_PAPER="en_US.iso885915"
LC_NAME="en_US.iso885915"
LC_ADDRESS="en_US.iso885915"
LC_TELEPHONE="en_US.iso885915"
LC_MEASUREMENT="en_US.iso885915"
LC_IDENTIFICATION="en_US.iso885915"
LC_ALL=en_US.iso885915

values of environment variables are:

$ echo $CLIENT_LOCALE
en_US.iso885915
$ echo $SERVER_LOCALE
en_US.iso885915
$ echo $DB_LOCALE
en_US.iso885915

Informix Server is running on other linux host and output
of the locale command on the server side is exactly the same
as on client side. (It means that locales on the client and
server sides are simular)

INFORMIXDIR and INFORMIX server environment variables are defined
correctly.

$INFORMIXDIR/etc/sqlhosts file contains correct values that point
to existent and running informix server.

I have no ideas what to look at in order to find the solution.

I would kindly appreciate you you or other forum members you provide me with any possible ways of solving the problem with 23101 error.

Thank you in advise

Andy.