Dear useRs, I would like to access a remote Oracle database through R but I just cannot find sufficient online information to do so. As a result, I am wondering if you can provide me with a link to a document that details the steps I need to undertake to successfuly complete the task (e.g., packages that I need to install/look into, the set up of the cnf file for remote access, etc.). My system: Windows XP, R2.6.1 Investigated packages: DBI, RODBC Thank you so much. Tudor -- Tudor Dan Bodea Georgia Institute of Technology School of Civil and Environmental Engineering Web: http://www.prism.gatech.edu/~gtg757i
Oracle connectivity
3 messages · Brian Ripley, Tudor Bodea
On Tue, 8 Jan 2008, Tudor Bodea wrote:
Dear useRs,
Please do NOT cross-post: I have removed R-help.
I would like to access a remote Oracle database through R but I just cannot find sufficient online information to do so. As a result, I am wondering if you can provide me with a link to a document that details the steps I need to undertake to successfuly complete the task (e.g., packages that I need to install/look into, the set up of the cnf file for remote access, etc.). My system: Windows XP, R2.6.1 Investigated packages: DBI, RODBC
With RODBC, all you need is the Oracle ODBC drivers and a DSN set up. That's not an R issue and your Oracle support should be able to help you do it. With DBI, you also need ROracle, and to compile it yourself for Windows. It has been done in the past, but not AFAIK recently.
Thank you so much. Tudor -- Tudor Dan Bodea Georgia Institute of Technology School of Civil and Environmental Engineering Web: http://www.prism.gatech.edu/~gtg757i
_______________________________________________ R-sig-DB mailing list -- R Special Interest Group R-sig-DB at stat.math.ethz.ch https://stat.ethz.ch/mailman/listinfo/r-sig-db
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
Dear Professor Ripley / R community: Thank you so much for your prompt reply. Happy New Year. Tudor Quoting Prof Brian Ripley <ripley at stats.ox.ac.uk>:
On Tue, 8 Jan 2008, Tudor Bodea wrote:
Dear useRs,
Please do NOT cross-post: I have removed R-help.
I would like to access a remote Oracle database through R but I just cannot find sufficient online information to do so. As a result, I am wondering if
you
can provide me with a link to a document that details the steps I need to undertake to successfuly complete the task (e.g., packages that I need to install/look into, the set up of the cnf file for remote access, etc.). My system: Windows XP, R2.6.1 Investigated packages: DBI, RODBC
With RODBC, all you need is the Oracle ODBC drivers and a DSN set up. That's not an R issue and your Oracle support should be able to help you do it. With DBI, you also need ROracle, and to compile it yourself for Windows. It has been done in the past, but not AFAIK recently.
Thank you so much. Tudor -- Tudor Dan Bodea Georgia Institute of Technology School of Civil and Environmental Engineering Web: http://www.prism.gatech.edu/~gtg757i
_______________________________________________ R-sig-DB mailing list -- R Special Interest Group R-sig-DB at stat.math.ethz.ch https://stat.ethz.ch/mailman/listinfo/r-sig-db
-- 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
-- Tudor Dan Bodea Georgia Institute of Technology School of Civil and Environmental Engineering Web: http://www.prism.gatech.edu/~gtg757i