[R] Informix database

[Prof Brian Ripley]

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

http://www.unixodbc.org/doc/informix.html

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 
is).

-- 
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