> install.packages('RODBC')Installing package into ?/home/vivek/R/x86_64-pc-linux-gnu-library/3.0? (as ?lib? is unspecified) Warning: unable to access index for repository https://cloud.r-project.org/src/contrib Warning message: package ?RODBC? is not available (for R version 3.0.2) Please suggest any way to either install the package or use another package to connect MySQL database from R. Regards, Vivek Kumar Singh PhD student, Information Systems Decision Sciences, MUMA College of Business, USF Phone- (813) 5809131 Web: http://vivek4.myweb.usf.edu/ [[alternative HTML version deleted]]
On Jun 28, 2016, at 3:36 PM, Vivek Singh <vivek4 at mail.usf.edu> wrote:> >> install.packages('RODBC') > Installing package into ?/home/vivek/R/x86_64-pc-linux-gnu-library/3.0? > (as ?lib? is unspecified) > Warning: unable to access index for repository > https://cloud.r-project.org/src/contrib > Warning message: > package ?RODBC? is not available (for R version 3.0.2) > > Please suggest any way to either install the package or use another package > to connect MySQL database from R. > > > Regards, > > Vivek Kumar SinghHi, Typically that error is an indication of a problem accessing and reading files on the CRAN mirror, possibly due to a proxy/firewall issue on your end and/or perhaps that your R installation does not support HTTPS (secure http). If the former, you may need to check with your SysAdmin. You might try to select a different CRAN mirror, including one that is not secure http (regular http:// URL) to see if that works. Also, note that the version of R that you are running (3.0.2) is from Sep of 2013, so quite dated. The current version is 3.3.1, which was just released this month. Regards, Marc Schwartz
Got a small fix for this issue. Sharing so that it may help others in future. options(repos='http://cran.rstudio.com/') Regards, Vivek Kumar Singh PhD student, Information Systems Decision Sciences, MUMA College of Business, USF Phone- (813) 5809131 Web: http://vivek4.myweb.usf.edu/ On Tue, Jun 28, 2016 at 5:11 PM, Marc Schwartz <marc_schwartz at me.com> wrote:> On Jun 28, 2016, at 3:36 PM, Vivek Singh <vivek4 at mail.usf.edu> wrote: > > > >> install.packages('RODBC') > > Installing package into ?/home/vivek/R/x86_64-pc-linux-gnu-library/3.0? > > (as ?lib? is unspecified) > > Warning: unable to access index for repository > > https://cloud.r-project.org/src/contrib > > Warning message: > > package ?RODBC? is not available (for R version 3.0.2) > > > > Please suggest any way to either install the package or use another > package > > to connect MySQL database from R. > > > > > > Regards, > > > > Vivek Kumar Singh > > > Hi, > > Typically that error is an indication of a problem accessing and reading > files on the CRAN mirror, possibly due to a proxy/firewall issue on your > end and/or perhaps that your R installation does not support HTTPS (secure > http). If the former, you may need to check with your SysAdmin. > > You might try to select a different CRAN mirror, including one that is not > secure http (regular http:// URL) to see if that works. > > Also, note that the version of R that you are running (3.0.2) is from Sep > of 2013, so quite dated. The current version is 3.3.1, which was just > released this month. > > Regards, > > Marc Schwartz > >[[alternative HTML version deleted]]
Try another mirror? Try the RMySQL package instead? Ask on R-sig-db? -- Sent from my phone. Please excuse my brevity. On June 28, 2016 1:36:47 PM PDT, Vivek Singh <vivek4 at mail.usf.edu> wrote:>> install.packages('RODBC') >Installing package into ?/home/vivek/R/x86_64-pc-linux-gnu-library/3.0? >(as ?lib? is unspecified) >Warning: unable to access index for repository >https://cloud.r-project.org/src/contrib >Warning message: >package ?RODBC? is not available (for R version 3.0.2) > >Please suggest any way to either install the package or use another >package >to connect MySQL database from R. > > >Regards, > >Vivek Kumar Singh > >PhD student, >Information Systems Decision Sciences, >MUMA College of Business, >USF >Phone- (813) 5809131 >Web: http://vivek4.myweb.usf.edu/ > > [[alternative HTML version deleted]] > >______________________________________________ >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.
Thanks Jeff. I used RMySQL instead and is working great. Regards, Vivek Kumar Singh PhD student, Information Systems Decision Sciences, MUMA College of Business, USF Phone- (813) 5809131 Web: http://vivek4.myweb.usf.edu/ On Tue, Jun 28, 2016 at 6:23 PM, Jeff Newmiller <jdnewmil at dcn.davis.ca.us> wrote:> Try another mirror? > Try the RMySQL package instead? > Ask on R-sig-db? > -- > Sent from my phone. Please excuse my brevity. > > On June 28, 2016 1:36:47 PM PDT, Vivek Singh <vivek4 at mail.usf.edu> wrote: > >> install.packages('RODBC') > >Installing package into ?/home/vivek/R/x86_64-pc-linux-gnu-library/3.0? > >(as ?lib? is unspecified) > >Warning: unable to access index for repository > >https://cloud.r-project.org/src/contrib > >Warning message: > >package ?RODBC? is not available (for R version 3.0.2) > > > >Please suggest any way to either install the package or use another > >package > >to connect MySQL database from R. > > > > > >Regards, > > > >Vivek Kumar Singh > > > >PhD student, > >Information Systems Decision Sciences, > >MUMA College of Business, > >USF > >Phone- (813) 5809131 > >Web: http://vivek4.myweb.usf.edu/ > > > > [[alternative HTML version deleted]] > > > >______________________________________________ > >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]]