Re: Whoops, that's ODBC to Informix?? (freudian slip!)

"Eric R. Gavin" <Eric_Gavin@maf.org> wrote: :Can anybody help me? The previous post tells all, but it's really about :Informix OLDS7.2, I just messed up on the title of the post. : :I have a runtime version of OLDS7.20 and can't seem to find INFORMIX-CLI :which (according to an Informix sales rep) comes w/ the Informix DB : :1) Is CLI all I need to set up an ODBC data source for use w/ another :program (i.e. MS Access) : :2) Where can I download CLI just by itself? You could use the CLI for ODBC access. It *is* an ODBC driver. I think they still charge for it though so you will have to buy it as a separate product. It uses I-Connect but that comes free with your engine. Your sales rep *may* confuse I-Connect with the CLI, but I may also not be up to date, so even the CLI *may* be free by now. If you haven't got it you can download it from the Informix web site. Try www.informix.com/tyrbuy and download the Relational Object Manager. It includes I-Connect and is an ok tool in itself. The best solution is to use the OpenLink ODBC drivers. They have several advantages in features and functionality (security is a significant point here, particularly as you plan to use MS Access). You can download a free trial version from their web site at www.openlinksw.com Make sure you get the server based version that do not need I-Connect at all (*not* the Lite version). Do read their whitepaper on ODBC and what they have done with it. 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