Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    6

    Unanswered: -23101: Unable to load locale categories

    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

  2. #2
    Join Date
    Dec 2009
    Posts
    1

    -23101: Unable to load locale catefories

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •