Re: INFORMIX CLI and SQLWindows

johnl@informix.com (Jonathan Leffler) wrote: :>From: fgm@soon.com (Frederic MARAND) :>Date: Wed, 19 Mar 1997 06:51:39 GMT :>X-Informix-List-Id: <news.35504> :> :>Nils.Myklebust@idg.no (Nils Myklebust) wrote: :>>Chen Yin Min <ymchen@global.com.my> wrote: :>>: Can Informix CLI for MS Windows works with SQLWindows? If yes, How? :> :>>Informix CLI is ODBC so it works as any ODBC driver works with :>>SQLWindows (Centura now isn't it?). I would suggest looking into other :>>ODBC drivers though. :> :>What's the difference between Informix CLI and Informix Connect, then ? :> :>I received both products names as an answer for Delphi C/S connectivity :>with Informix. : :Informix-Connect is the package of software (and a licence) which allows :you to run ESQL/C based applications on a machine where you don't have the :necessary material available via another Informix package. It allows you :to connect to databases, etc, hence its name. I know this applies to Unix; :the rules under Windows may be mildly different. It's the same - or I don't know of any differences. However there are also many other tools than ESQL/C on MS Windows that can directly use Informix Connect (like Delphi) without you having to have an ESQL/C program in sight. :Informix-CLI is Informix's version of ODBC (give or take the issues of :who actually wrote it, etc). : :I don't know which product you need for Delphi. If Delphi needs ODBC, then :you'd presumably need Informix-CLI. You might also need Informix Connect, :but I don't know. Delphi can connect via Informix Connect (using some "native" library delivered with Delphi) or use ODBC and therefore Informix CLI or better another ODBC driver. From postings here at c.d.i. it seems most are using Informix Connect (previously Informix Net). Whether that's due to a belief that this driver will give better performance ("native" driver you know :-) or there are some problems with using ODBC I don't know. In any case I would excpect the same or better performance with ODBC (most probably better if you use the right driver, perhaps worse if you use Informix CLI which is after all another layer on top of Informix Connect). 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