[R-sig-DB] Oracle connectivity

[Tudor Bodea]

Dear Professor Ripley / R community:

Thank you so much for your prompt reply.

Happy New Year.

Tudor

Quoting Prof Brian Ripley <ripley using 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 using stat.math.ethz.ch
> > https://stat.ethz.ch/mailman/listinfo/r-sig-db
> >
>
> --
> Brian D. Ripley,                  ripley using 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