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.