My Oracle Support Banner

DG4ODBC To An Informix Database Returns "Invalid Year In Date {HY000,NativeErr= -1204}" (Doc ID 2214224.1)

Last updated on OCTOBER 17, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.2 to 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.


Using version 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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.