Re: ODBC failed, invalid date

Posted in 1997

Nils Myklebust — Thu, 23 Jan 1997 09:38:49 GMT — source: Informix-list mailing list archive (1991-1998)

If you have an I-Net based ODBC driver I think you have to set the DBDATE variable in I-Net to the same format you have spesified (or is the default) in MS Windows. With server based ODBC drivers this problem shouldn't ever occur. daveb@apollo.hp.com (Dave Belanger) wrote: :I am running Access 2.0 and I am having trouble attaching to Informix tables :that have a date in them. I get the error "ODBC call failed, invalid date, : time, or timestamp value(#0). What can I do to read Informix dates in :Access? : :Dave Belanger :daveb@apollo.hp.com : Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org