Re: ODBC: Openlink, Intersolv or Informix?

John Clynes wrote: > > Tony, > Informix's current 32 (2.80) bit driver is a pure INFORMIX driver. i.e. they > designed it themselves and it does not work with Informix V5. Its a pile of > shit to be honest. I concur with this one. This version seems to have problems handling dates. For some strange reason, this driver insists on reversing the day and month values. The older 2.5x driver also seems to have this problem but can be fixed by setting GL_DATE(?). Doing the same for 2.80 has no effect. > Intersolv's driver 3.11 is bang down the line reliable as always. Also, > Intersolv tech support can resolve any problems you might have very quickly. > I have not found this to be the case with Informix. > > Openlink's driver promise a lot but I couldn't get it to work (the lite > client side version). > We may look again at openlink in the future as there are some very nice > features promised. > > So basically, choose anything, just not the Informix driver. (The Intersolv > 3.10 driver that comes with the CLI SDK download pack has a couple of known > bugs so pay the extra few pounds and the the 3.11) What bugs does 3.10 have? > If I sound vehement, its because I wasted a LOT of time with this crap > (we're on Informix 5.10) I don't blame you. As an aside, we already ditched that pesky New Era (at my instigation). Now if I can only convince the group to bring in other databases into the picture, as a prelude to ditching everything Informix that we have. The last attempt was almost successful, until that Dynamic-4GL thing reared its head. We could have replaced all of our 4GL code in one stroke; but now I guess those chunks of 4GL code will have to live a bit longer. Jun Nolasco