[R] Connect to Oracle database via ODBC

Eric Berger er|cjberger @end|ng |rom gm@||@com
Mon Aug 5 14:19:08 CEST 2019


Hi Ahson,
Many people use R via RStudio, an IDE that has both free and non-free
versions.
RStudio has invested a lot of effort into making it easier to establish
connections to databases.
If this sounds of interest to you, take a look at
https://db.rstudio.com/

HTH,
Eric


On Mon, Aug 5, 2019 at 2:54 PM Marc Schwartz via R-help <
r-help using r-project.org> wrote:

>
> > On Aug 5, 2019, at 7:03 AM, e-mail ma015k3113 via R-help <
> r-help using r-project.org> wrote:
> >
> > Dear All, can anyone point me towards information for connecting to a
> Oracle instance via DSN. I have already established a ODBC connection.
> >
> > Sorry if this is very elementary-I am just getting started with R after
> using SAS for almost 2 decades.
> >
> > Kind regards
> >
> > Ahson
>
>
> Hi,
>
> Look at the RODBC package on CRAN by Prof. Ripley:
>
>   https://cran.r-project.org/web/packages/RODBC/index.html
>
> and be sure to read the package vignette for additional information:
>
>   https://cran.r-project.org/web/packages/RODBC/vignettes/RODBC.pdf
>
> There is also the r-sig-db e-mail list, which is focused in this domain,
> and where follow up questions should be posted:
>
>   https://stat.ethz.ch/mailman/listinfo/r-sig-db
>
> Regards,
>
> Marc Schwartz
>
> ______________________________________________
> R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>

	[[alternative HTML version deleted]]



More information about the R-help mailing list