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
> On Aug 5, 2019, at 7:03 AM, e-mail ma015k3113 via R-help <r-help at 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 > > AhsonHi, 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
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 at r-project.org> wrote:> > > On Aug 5, 2019, at 7:03 AM, e-mail ma015k3113 via R-help < > r-help at 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 at 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]]
Dear Marc, Thanks-much appreciated Kind regards Ahson> On 05 August 2019 at 12:54 Marc Schwartz <marc_schwartz at me.com> wrote: > > > > > On Aug 5, 2019, at 7:03 AM, e-mail ma015k3113 via R-help <r-help at 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 >