Re: Informix 7.2 Y2K Issue

From: Robert Trenczer <rtrencze@vbws01.ba.ford.com> > >I need some help solving a Y2K issue I have with Informix. Here's the >situation: > >I wrote a front-end system in VB that queries, displays, and updates >multiple tables in Informix. I am using an ODBC connection. On queries >that update date fields in the db, I find that sending a date in the >format '01/01/00' is saved in Informix as '01/01/1900'. I verified in >ISQL this same problem using the identical update query. > >My DBA changed the environment variable DBCONFIG to 'F'. In ISQL, the >problem disappeared. '01/01/00' was correctly interpretted as >'01/01/2000'. But when I used my front-end system, it still came up as >1900. > >Does anyone have a suggestion other than changing my front-end to accept >4-digit years? I think your DBA probably changed DBCENTURY, not DBCONFIG, and you should find the same "environment variable" in your SETNET program. If you don't, you need to upgrade your SETNET (client SDK). HTH. -- Bye now, Obnoxio "The one with the smartest marketing department wins" ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com