Discussion:
ODBC Driver Problems
(too old to reply)
g***@nhs.net
2006-03-24 08:18:00 UTC
Permalink
I have just changed PC's and am having difficulty getting my Informix
ODBC Driver to work.

We are running Informix on a Unix box, and using Informix driver v 3.32
32bit which was working without any problems on my old PC (and still
is)

However, on my new PC I am getting the following error:-
The displayed locale and codeset have not been found on the client
machine. Using these locale/codeset will result in a -23101 Unable to
load locale categories error. Please install the locales.

The locales being specified in the driver configuration are
en_US.CP1252, and all ODBC Registry Entries are identical on both my
old and new PC's.

Please Help
Superboer
2006-03-24 10:50:08 UTC
Permalink
sounds like INFORMIXDIR
env var is not set properly.

Superboer
g***@nhs.net
2006-03-24 14:22:42 UTC
Permalink
How can this be?

INFORMIXDIR is set on the Unix Box, and everything is working fine
there

The ODBC settings I am trying to use worked without any problems on the
old PC - just having problems on the new PC
Jonathan Leffler
2006-03-25 03:56:02 UTC
Permalink
Post by g***@nhs.net
How can this be?
INFORMIXDIR is set on the Unix Box, and everything is working fine
there
Good. So the problem probably isn't on the Unix box.
Post by g***@nhs.net
The ODBC settings I am trying to use worked without any problems on the
old PC - just having problems on the new PC
Oh - and have you done the same registry setup on the new PC that you
did on the old one? SETNET32 might be the tool you need. I'm not an
expert on ODBC or Windows, so I could be spouting nonsense, but the
message (-23101 - cannot load locale categories) you are getting is
fully consistent with INFORMIXDIR not set. Have you got I-Connect or
ClientSDK installed on the PC? Does it have SETNET32 in the Informix
bin directory? Have you used it?

Windows is a weird system - and the registry confuses the heck out of
me. But I strongly suspect the answer lies there.
g***@nhs.net
2006-03-24 14:22:41 UTC
Permalink
How can this be?

INFORMIXDIR is set on the Unix Box, and everything is working fine
there

The ODBC settings I am trying to use worked without any problems on the
old PC - just having problems on the new PC
D***@carmax.com
2006-03-24 14:52:09 UTC
Permalink
Did you run setnet32 on the new pc? Did you test the connections once you
created the datasources? Are you sure INFORMIXDIR is set? What about
ILogin?




***@nhs.n
et
Sent by: To
informix-list-bou informix-***@iiug.org
***@iiug.org cc

Subject
03/24/2006 09:22 Re: ODBC Driver Problems
AM









How can this be?

INFORMIXDIR is set on the Unix Box, and everything is working fine
there

The ODBC settings I am trying to use worked without any problems on the
old PC - just having problems on the new PC
Deniz Karakus
2006-03-24 15:12:05 UTC
Permalink
Did you try to replace old GLS directory to new one?

And is there any regional difference between old OS and new OS?


Deniz
Jack Miller
2006-03-30 19:51:55 UTC
Permalink
Refer to http://www.synametrics.com/SynametricsWebApp/WinFAQ.jsp and
scroll down to the section for Informix.
Post by g***@nhs.net
I have just changed PC's and am having difficulty getting my Informix
ODBC Driver to work.
We are running Informix on a Unix box, and using Informix driver v 3.32
32bit which was working without any problems on my old PC (and still
is)
However, on my new PC I am getting the following error:-
The displayed locale and codeset have not been found on the client
machine. Using these locale/codeset will result in a -23101 Unable to
load locale categories error. Please install the locales.
The locales being specified in the driver configuration are
en_US.CP1252, and all ODBC Registry Entries are identical on both my
old and new PC's.
Please Help
tarod35
2006-03-31 07:58:27 UTC
Permalink
Hola, teclea en la maquina unix:

$ env|grep CLIENT_LOCALE

Tienes que poner la misma en el cliente ODBC, en mi caso es:
CLIENT_LOCALE=es_es.8859-1
DB_LOCALE=es_es.8859-1

Seguramente en tu caso serĂ¡:

CLIENT_LOCALE=en_US.8859-1
DB_LOCALE=en_US.8859-1

saludos.

Loading...