Message-ID: <Pine.LNX.4.61.0411181518340.3711@gannet.stats>
Date: 2004-11-18T15:22:56Z
From: Brian Ripley
Subject: Informix database
In-Reply-To: <b1d31504041118063118ae4735@mail.gmail.com>
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