Last post Aug 23, 2010 08:15 PM by johnsonlim026
Aug 19, 2010 06:36 AM|johnsonlim026|LINK
Hi, there is an upgrade to my infimacs server and my web application encounter this error after the infimacs is upgraded.
Below is the information on the server before/after the upgrade.
Solaris 8 Solaris 10
IDS 9.40 IDS 11.50
The web server where the web application hosted is running IBM Informix Connect 2.81. There is no such error before the upgrade is done.
As a developer, i have IBM Informix Client-SDK 2.90 installed on my local pc and debug the page where the read is needed from infimacs but no such error found.
The error come out only when it is hosted on the web server where IBM Informix Connect 2.81 is installed.
I have gone through many articles and it suggest me to set the environement variable in the server : DB_LOCALE=en_us.819.
I haven't try this solution but i think that this might not be the best solution.
Is it possible to to to have this setting in the web application ?Does anyone has idea on this?Is it true that there is no other solution than setting the environemetn variable DB_LOCALE?
Below is my connection string
Aug 23, 2010 08:15 PM|johnsonlim026|LINK
I have got the solution!!
Just set the database locale and client locale in the code as below:
oIFXCConnection.DatabaseLocale = "en_US.819"
oIFXCConnection.ClientLocale = "en_US.CP1252"