[R] Connecting R Running on Linux to an Oracale Database Running on Another Server

[Michael Lapsley]

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.

Michael
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._