Let me put this issue this way i have 4 databases on my informix Server 11.5 say A,B,C,D. I can connect to B,C,D that are default informix database and A is created by the DBA
About A - 1)this database is created from earlier exisiting database on an older version
2) Not sure what was the platfrom on which the informix was running form which this database has been imported
3) the newer version of Informix runs on window Server 2003
and when i try to connect to A it gives me 23197: Database locale informartion mismatch, one more thing my informix database is on window server 2003 which i remotely access using my pc any help would be really appreciated
the name of my client is dbaccess
i selected the sysmaster database then
Select * from sysdbslocale;
got the value for dbs_collate en_US.57372
went into the registry
changed the value of db_locale and client_locale to the above
but the same error exists
there is one more thing i wanna bring to your notice that after i use select * from sysdbslocale;
i get the value for the three default database as en_US.819 does that make a diference
Check the environment variables in command line by: echo %DB_LOCALE%.
If it is not set:
Try to set environmental variables in command line(before executing dbaccess).
"set CLIENT_LOCALE=...." the same for the db_locale.