RE: [Informix][Informix ODBC Driver] Database locale information mismatch

You could try issuing the following statement and see what the engine is configured for. onstat -g env This will give you the environment of the engine. I believe it is listed there what the locale is set to. David -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of bobkot@gmail.com Sent: Tuesday, May 23, 2006 7:28 AM To: informix-list@iiug.org Subject: [Informix][Informix ODBC Driver] Database locale information mismatch I have download ClientSDK 2.90.TC4 I am trying to connect to an IDS10 database. My iLogin works fine, but I cannot set up the ODBC driver, I keep getting the message "[Informix][Informix ODBC Driver] Database locale information mismatch" I cannot leave it blank, under environment, and I cannot find any matching pairs. Can somebody help. XP client and Linux server _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list

Version 10.00.UC4E is what I am running. How do I determine what the database was created with ? I have no customer support - that is me - so where to for the patches ? Would that be for the IDS or the SDK

To find out what's the database locale in your environment go to the server instance window/shell and do "onstat -g env | grep -i db_locale" this will give you the value of DB locale for your server. You can also get the same from dbaccess, go to the database you are connecting to and go to "info" and then "Nls" ..there you should be able to see db locale for your database. Once you come to know the value of your database ...use the same value in your DSN setup for ODBC or if you are using DSNLESS connection then "DLOC=<the value>" should be part of your connection string ... In terms of patch you must be asking for CSDK(i.e ODBC) patch not IDS. As you said you are using IDS on Linux and if you are sure you only created the database on this server and didn't use any DB_LOCALE setting while creating the database then by default its going to be en_US.819 or en_US.8859-1 . So try one of these two values it should work !!! Thanks & Regards -Shesh bobkot@gmail.com Sent by: informix-list-bounces@iiug.org 05/24/2006 11:44 AM To informix-list@iiug.org cc Subject Re: [Informix ODBC Driver] Database locale information mismatch Version 10.00.UC4E is what I am running. How do I determine what the database was created with ? I have no customer support - that is me - so where to for the patches ? Would that be for the IDS or the SDK _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list