Skip to content

Not able to install RODBC package

5 messages · Vivek Singh, Marc Schwartz, Jeff Newmiller

Vivek Singh
# 
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/
Marc Schwartz
#
On Jun 28, 2016, at 3:36 PM, Vivek Singh <vivek4 at mail.usf.edu> wrote:
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
Vivek Singh
# 
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:

            

      
      
      
    

        

  
  


  


      

    

    

      
      

        


  

        

      Jeff Newmiller
    

    

      
      #
    

  


  

      
Try another mirror?
Try the RMySQL package instead? 
Ask on R-sig-db?

  
    

      
      
    

  


  


      

    

    

      
      

        


  

        

      Vivek Singh
    

    

      
      #
    

  


  

      
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: