[R] Informix database

[Yasser El-Zein]

The Informix linux ODBC driver is not free, isn't it?
Shoudl I be worried of ODBC performance on linux? 


On Thu, 18 Nov 2004 15:22:56 +0000 (GMT), Prof Brian Ripley
<ripley at stats.ox.ac.uk> wrote:
> 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
>