Access 97 and Informix ODBC

Posted in 1998

Edward Villalovoz — Mon, 24 Aug 1998 21:33:02 -0700 — source: Informix-list mailing list archive (1991-1998)

I have an odbc connection between access 97 and informix 7.x on solaris. When I run a pass through query on one of the fields in informix that is set to "datetime hour to min", i don't get the "12:00" that i expect. I get "11/11/99 12:00:00 PM". The field only contains "12:00". If I link the table through the odbc driver I get the same result when I view the data. If I change the format on the the field in the linked table to "short time" then I get the results I want, but I can't run my pass through query. I am currently running the last Informix SDK, 2.02?. I've tried other odbc drivers, Intersolv 3.11 and OpenLink. Anyone have a cool work around or fix? Thanks in advance....