Problem with ODBC non-wire connection to Informix

[ascen]

Hello,

I tried to configure connection to informix with non-wire driver ( I have just accomplished to connect with wire driver).
And I got the following error when I try to import some metadata:

Code: Select all

DSR.MetaGeta(GET.TABLES)(SQLConnect('piotrek2','djankows')): BCI Error:
SQLSTATE=S1000,CODE=-23101,[DataStage][SQL Client][ODBC][DataDirect][ODBC Informix driver][Informix]Unable to load locale categories.

Entry in .osbc.ini:

Code: Select all

[piotrek2]
Driver=/dsqs/datastage/Ascential/DataStage/branded_odbc/lib/VMinf5120.so
Description=piotrek2
ApplicationUsingThreads=1
CancelDetectInterval=0
CursorBehavior=0
Database=insur
EnableInsertCursors=0
GetDBListFromInformix=1
HostName=10.5.160.18
LogonID=djankows
password=cenins45
Protocol=onsoctcp
ServerName=prod
Service=ids940cen
TrimBlankFromIndexName=1

In dsenv:

Code: Select all

export INFORMIXDIR=/dsqs/informix10
export INFORMIXSERVER=prod
export PATH=$PATH:$INFORMIXDIR/bin
export LIBPATH=$LIBPATH:$INFORMIXDIR/lib/esql
export ONCONFIG=onconfig.prod

#-------------------------------------------------
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql:$INFORMIXDIR/lib/client/csm:/usr/lib
LANG=C
export LANG

And finally in uvodbc.config:

Code: Select all

<piotrek2>
DBMSTYPE = ODBC

Doea anybody know what is wrong?

[ascen]

Problem solved.
I have added some environment variables:

export INFORMIXSQLHOSTS=$INFORMIXDIR/etc/sqlhosts

export SERVER_LOCALE="pl_pl.Latin-2@prok"
export DB_LOCALE="pl_pl.Latin-2@prok"
export CLIENT_LOCALE="pl_pl.Latin-2"

export DBMONEY="."
export DBCENTURY=C
export DBDATE=Y4MD-

Now I have got working Informix CLI stage :D

Best regards,
Piotrek