Informix Date format And ODBC
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C08544.5E65D610 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, everybody: I'm connecting to Informix 7.0 from a windows application via ODBC. I know the date format is set throght setnet32 in = the DBDATE variable, but if i leave it unset.... Which is the dafault date format? Where is it read from? We had an aplication working without setting DBDATE with informix 5, and sending date constants in queries in mm/dd/yyyy = format, then we upgraded to Informix 7.0 and the aplication stoped working. It recieved an error message from the server saying "Invalid month date". = So we tried changing the format to dd/mm/yyyy and started working again. So = we configured the client to know which Informix version it was connecting = to. Everithing went fine for two months, the apps = reading from configuration files the version number of the server, and if 5 formating dates in queries to mm/dd/yyy, if 7 to dd/mm/yyy. Last night the server was restarted and today = morning we had users complaining about error messages saying "Invalid Date Month" = on aplications running against a Informix 7 Server. I switched the flag to = 5 to make the app format dates to mm/dd/yyy and the app is working properly. =20 The big question is: Wich is the parameter that = tells the date format if it is not set by the client? Thanks in advance =20 =20 Sebasti=E1n Streiger Departamento Sistemas Red Megatone Argentina sstreige@redmegatone.com =20 ------_=_NextPart_001_01C08544.5E65D610 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 5.00.2614.3500" name=3DGENERATOR></HEAD> <BODY> <DIV><FONT face=3DArial size=3D2><SPAN class=3D080314313-23012001>Hi,=20 everybody:</SPAN></FONT></DIV> <DIV><FONT face=3DArial size=3D2><SPAN=20 class=3D080314313-23012001> &nb= sp; =20 I'm connecting to Informix 7.0 from a windows application via=20 ODBC.</SPAN></FONT></DIV> <DIV><FONT face=3DArial size=3D2><SPAN=20 class=3D080314313-23012001> &nb= sp; =20 I know the date format is set throght setnet32 in the DBDATE variable, = but if i=20 leave it unset.... Which is the dafault date = format?</SPAN></FONT></DIV> <DIV><FONT face=3DArial size=3D2><SPAN=20 class=3D080314313-23012001> &nb= sp; &nb= sp;Where=20 is it read from?</SPAN></FONT></DIV> <DIV><FONT face=3DArial size=3D2><SPAN=20 class=3D080314313-23012001> &nb= sp; =20 We had an aplication working without setting DBDATE with informix = 5, and sending date constants in queries in mm/dd/yyyy format, = then we=20 upgraded to Informix 7.0 and the aplication stoped working. It recieved = an error=20 message from the server saying "Invalid month date". So we tried = changing the=20 format to dd/mm/yyyy and started working again. So we configured the = client to=20 know which Informix version it was connecting to.</SPAN></FONT></DIV> <DIV><FONT face=3DArial size=3D2><SPAN=20 class=3D080314313-23012001> &nb= sp; =20 Everithing went fine for two months, the apps reading from = configuration files=20 the version number of the server, and if 5 formating dates in queries = to=20 mm/dd/yyy, if 7 to dd/mm/yyy.</SPAN></FONT></DIV> <DIV><FONT face=3DArial size=3D2><SPAN=20 class=3D080314313-23012001> &nb= sp; =20 Last night the server was restarted and today morning we had users = complaining=20 about error messages saying "Invalid Date Month" on aplications running = against=20 a Informix 7 Server. I switched the flag to 5 to make the app format = dates to=20 mm/dd/yyy and the app is working properly.</SPAN></FONT></DIV> <DIV><FONT face=3DArial size=3D2><SPAN=20 class=3D080314313-23012001></SPAN></FONT> </DIV> <DIV><FONT face=3DArial size=3D2><SPAN=20 class=3D080314313-23012001> &nb= sp; =20 The big question is: Wich is the parameter that tells the date = format if=20 it is not set by the client?</SPAN></FONT></DIV> <DIV><FONT face=3DArial size=3D2><SPAN=20 class=3D080314313-23012001> Thanks = in=20 advance</SPAN></FONT></DIV> <DIV><FONT face=3DArial size=3D2><SPAN=20 class=3D080314313-23012001></SPAN></FONT> </DIV> <DIV><FONT face=3DArial size=3D2><SPAN=20 class=3D080314313-23012001></SPAN></FONT> </DIV> <DIV><FONT face=3DArial size=3D2><SPAN = class=3D080314313-23012001></SPAN></FONT><FONT=20 size=3D2>Sebasti=E1n Streiger<BR>Departamento Sistemas<BR>Red = Megatone</FONT></DIV> <DIV><SPAN class=3D080314313-23012001></SPAN><FONT size=3D2>A<SPAN=20 class=3D080314313-23012001>rgentina</SPAN><BR>sstreige@redmegatone.com<B= R></FONT></DIV> <DIV> </DIV></BODY></HTML> ------_=_NextPart_001_01C08544.5E65D610--