[sorry, but this is a re-post - I forgot to set the subject line the first time around] Hello, I would like to access an Oracle database running on Solaris from R on my linux desktop. I have had a look at the R Data Import/Export manual, and downloaded RODBC and unixODBC, but I am still quite confused about how to proceed. It appears to me that I still need to get an Oracle ODBC driver, and the only one I can find is from Easysoft for 880 euros, which is not available for this project. Is there any free software which will enable R on linux to talk to Oracle on Solaris (both reading and writing data) ? My R setup is as follows: platform i386-pc-linux-gnu arch i386 os linux-gnu system i386, linux-gnu status major 1 minor 5.1 year 2002 month 06 day 17 language R Thanks, Luke Whitaker.
ripley@stats.ox.ac.uk
2003-Jan-03 14:39 UTC
[R] R talking to Oracle, ODBC drivers available ?
Have you looked at ROracle on CRAN? I don't know if it will work to a remote Solaris database, as we have no need of that. On Fri, 3 Jan 2003, Luke Whitaker wrote:> > [sorry, but this is a re-post - I forgot to set the subject line > the first time around] > > Hello, > > I would like to access an Oracle database running on Solaris from > R on my linux desktop. I have had a look at the R Data Import/Export > manual, and downloaded RODBC and unixODBC, but I am still quite confused > about how to proceed. It appears to me that I still need to get an Oracle > ODBC driver, and the only one I can find is from Easysoft for 880 euros, > which is not available for this project. > > Is there any free software which will enable R on linux to talk to Oracle > on Solaris (both reading and writing data) ? > > My R setup is as follows: > > platform i386-pc-linux-gnu > arch i386 > os linux-gnu > system i386, linux-gnu > status > major 1 > minor 5.1 > year 2002 > month 06 > day 17 > language R > > Thanks, > > Luke Whitaker. > > ______________________________________________ > R-help at stat.math.ethz.ch mailing list > http://www.stat.math.ethz.ch/mailman/listinfo/r-help >-- 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
I believe that Oracle provides ODBC drivers for the server side--provided you have an Oracle administrator who can figure out how to install them. I couldn't find much documentation. For another commercial source see www.openlink.com (don't know if they have client drivers for Linux). -Don At 1:10 PM +0000 1/3/03, Luke Whitaker wrote:>[sorry, but this is a re-post - I forgot to set the subject line > the first time around] > >Hello, > >I would like to access an Oracle database running on Solaris from >R on my linux desktop. I have had a look at the R Data Import/Export >manual, and downloaded RODBC and unixODBC, but I am still quite confused >about how to proceed. It appears to me that I still need to get an Oracle >ODBC driver, and the only one I can find is from Easysoft for 880 euros, >which is not available for this project. > >Is there any free software which will enable R on linux to talk to Oracle >on Solaris (both reading and writing data) ? > >My R setup is as follows: > >platform i386-pc-linux-gnu >arch i386 >os linux-gnu >system i386, linux-gnu >status >major 1 >minor 5.1 >year 2002 >month 06 >day 17 >language R > >Thanks, > >Luke Whitaker. > >______________________________________________ >R-help at stat.math.ethz.ch mailing list >http://www.stat.math.ethz.ch/mailman/listinfo/r-help-- -------------------------------------- Don MacQueen Environmental Protection Department Lawrence Livermore National Laboratory Livermore, CA, USA --------------------------------------