IBM Informix ODBC Connection Error – [Informix ODBC Driver][Informix]Database locale information mismatch.
I have been setting up a number of ODBC connections in the last few days, that are to be used in an SSIS package. The connections enable me to access a number of IBM Informix Servers in various locations (DR & TEST sites) and extract specific data for reporting. However, I was having a considerable amount of aggravation with a particular connection that kept giving the following Error:
I found out that (unsurprisingly) there is a Database Locale property – located in the Environment tab of the Create New Data source dialog box. This needed to be set to en_US.819.
This fixed my issue and I can now connect easily to each of the Informix instances. Why it was different for this particular connection I have no idea, but for now, this question will have to wait. I’ll follow this up in due course.
use en_us.8859-1 as the database locale. It gets changed to hex 819 in the connection string.
Thanks for the tip!
Thanks!!!