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
Hi, see DBI: R/S-Plus Database Interface, maybe it could help you: http://stat.bell-labs.com/RS-DBI http://www.ci.tuwien.ac.at/Conferences/DSC-2001/Proceedings/HothornJamesRipley.pdf I found: Other Database Connections from S-Plus Depending on the platform it's running, S-Plus provides access to some DBMS through the importData/exportData functions. Under Microsoft Windows you may import/export data through ODBC; under Solaris (and only Solaris) you may import data from Informix, Oracle, and Sybase. See also the function executeSQL. Best regards Vito You 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. Thankx for the help ====Diventare costruttori di soluzioni Became solutions' constructors "The business of the statistician is to catalyze the scientific learning process." George E. P. Box Visitate il portale http://www.modugno.it/ e in particolare la sezione su Palese http://www.modugno.it/archivio/palese/
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