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, [EMAIL PROTECTED] 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
______________________________________________ [EMAIL PROTECTED] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html