DG4ODBC To An Informix Database Returns "Invalid Year In Date {HY000,NativeErr= -1204}"

(Doc ID 2214224.1)

Last updated on FEBRUARY 01, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

Using version 11.2.0.4 of DG4ODBC, running on OEL6 Linux x86_bit platform, the following error occurs
from some type of dml being submitted via the gateway.

hgopoer, line 231: got native error -1204 and sqlstate HY000; message follows...
[Informix][Informix ODBC Driver][Informix]Invalid year in date {HY000,NativeErr = -1204}
Exiting hgopoer, rc=0 at 2016/11/04-15:07:16
hgopars, line 464: calling SQLPrepare got sqlstate HY000
Exiting hgopars, rc=28500 at 2016/11/04-15:07:16 with error ptr FILE:hgopars.c LINE:494 FUNCTION:hgopars() ID:Prepare stmt


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms