Re: Informix and ODBC

If its Informix 3.30, its unlikely OBDC access is available and dates beyond 31Dec99 will be massively incorrect. Bernhard Gramberg <mail@gramberg.de> wrote in message news:37D4E83E.C73D600E@gramberg.de... > May be, SQL-Retriever (on SCO-Unix) may help you > > > Tyson Oswald schrieb: > > > Hello All, > > > > Is there an ODBC driver available that I can useto connect to and > > older version of Informix I believe it's Informix 3.x on on NCR 386/486 > > Unix server. I work for a company that has an old imaging system and > > they want to extract images that are stored on optical platters into > > they're Sybase DB. I would imagine it would be easier if I had an ODBC > > driver for Windows, so I could just pull it from one Informix to put it > > into Sybase. > > > > If anyone has any insight on this, it would greatly appreciated. > > > > Thanks > > > > Tyson Oswald >

In article <GD6B3.28693$aX6.47043@news20.bellglobal.com>, joel@askjoel.com says... >If its Informix 3.30, its unlikely OBDC access is available and dates beyond >31Dec99 will be massively incorrect. That may be one reason they're finally moving away from 3.3. >> > Unix server. I work for a company that has an old imaging system and >> > they want to extract images that are stored on optical platters into >> > they're Sybase DB. Assuming it is Informix 3.3, wonder how they stored the data? IIRC, Informix 3.3 didn't have a byte or blob data type - which would make just unloading the data and importing it into another database dicey. Using the ALL-II libraries to unload the data to a disk file (of known format) then loading this file into the other database would seem to be the best bet - assuming someone there hasn't thrown away the manuals and still knows dbfinds, dbstructviews, dbselfield, etc. :-) -- William Harris william@carsinfo.com God created everything in six days... but he didn't have to worry about backword compatibility.