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. Thankx for the help
Informix database
3 messages · Yasser El-Zein, 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
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