Connecting R Running on Linux to an Oracale Database Running on Another Server
On Tue, 27 Mar 2001, Michael Lapsley wrote:
On Tue, Mar 27, 2001 at 10:52:25AM -0500, Richard A. Bilonick wrote:
I need to access an Oracle database running on another server from my Linux box running R. I've downloaded RODBC but I have a sinking feeling I need more things to do this.
Yes, it is not easy, although I know of one person who has succeeded (I do not use oracle myself and have no access to it). AFAIR you will need unixODBC plus an oracle driver. There is a beta driver from www.easysoft.com for which you need a (free) licence. There is also a freeware driver in development but the version number is currently very low and I do not think there is much functionality yet. I think you also need some of the oracle libs. The idea is that you install unixodbc, install & licence the oracle driver, then set up a .odbc.ini file with the connection information in it. If I remember correctly there is a bug _requiring_ that the password appears in the .odbc.ini. In short, you need to want to do this quite badly, although, as I said, I do know of one person who succeeded. PS: as a further complication, there was/is an oracle odbc driver bug which requires/required a complile flag to be set in RODBC.c as a workaround. If you can get as far as getting a connect we can deal with that later if it is still necessary.
No longer, I believe, unles Oracle actaully lies about the number of rows in a table. I will shortly need to do this, although may just use Windows where we have an Oracle ODBC driver. Good to hear from you, as I at least have had no reply to several emails. At the Vienna DSC-2001 it was decided to set up a R-dbs Special Interest Group (mainly an email list) and I hope you will be able to participate. Meanwhile I have a few bug reports outstanding, and would it help to re-submit to you the changes I am currently using? Brian
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 272860 (secr) Oxford OX1 3TG, UK Fax: +44 1865 272595 -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._