[R] Informix database

Prof Brian Ripley ripley at stats.ox.ac.uk
Thu Nov 18 16:22:56 CET 2004

On Thu, 18 Nov 2004, Yasser El-Zein wrote:

> We use Informix database. I was able to connect to the database with
> S-PLUS by using its CONNECT/Java through the JDBC driver.
> How can I connect to Informix with R, wither using JDBC or any other
> method? we run Linux so I prefer a method other than ODBC.

ODBC runs perfectly well under Linux.  There is an Informix driver, see


R does not have a JDBC driver, and trying to use one under RSJava is 
likely to be *far* more work that using ODBC.

Vito Ricci mentioned DBI, but I am unaware of any Informix backend for 
DBI, which is not of itself a DBMS interface, more a meta-driver (as ODBC 

Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

More information about the R-help mailing list