How informix applications are typical built ?

Hi, I'm looking for Marketing data on how application(home grown application not packaged application) that is written on top of Informix interact with the database. I assume it can be one of the following options : OLEDB\\ODBC\\JDBC\\ADO.NET 4GL ESQL\\C I'm interested to know what is the most common way for the application to be built. Thanks, Gil

On Mon, 2006-09-25 at 20:41, Gil Lapid wrote: > Hi, > > I'm looking for Marketing data on how application(home grown > application not > packaged application) that is written on top of Informix interact with > the > database. > I assume it can be one of the following options : > > OLEDB\\ODBC\\JDBC\\ADO.NET > 4GL > ESQL\\C There's also ESQL/J (the Java equivalent of ESQL/C), ESQL/Cobol (if anybody still uses that) and a C++ library. According to the documentation it's also possible to build client applications using the libmi datablade API, but I don't know anybody that has done so. Some programming languages support Informix connectivity using third-party modules that use some of the above under the hood. PHP and Python have Informix modules that are implemented in ESQL/C, and I believe the Perl module is also implemented in ESQL/C. Even though these modules are implemented in ESQL/C, the programmer is shielded from that and doesn't use ESQL/C per se. > I'm interested to know what is the most common way for the application > to be > built. The plural of "anecdote" is not "data", but here goes. I use primarily Informix 4GL (and derivatives/successors), some PHP, and whenever I can, I use Python. The mix is probably 95% 4GL, 3% PHP, and 2% Python. Hope this helps, Carsten.