Skip to content

Unable to load packages RODBC and RODBCext in R

4 messages · Paul Bernal, Bert Gunter, Jeff Newmiller

Paul Bernal
# 
Dear all,

Hope you are doing great. I am currently using R version 3.4.1 ("Single
Candle") and was trying to install packages RODBC and RODBCext using the
following steps:
Installing package into ?C:/Users/PaulBernal/Documents/R/win-library/3.4?
(as ?lib? is unspecified)
also installing the dependency ?RODBC?

trying URL '
https://mirrors.dotsrc.org/cran/bin/windows/contrib/3.4/RODBC_1.3-15.zip'
Content type 'application/zip' length 831635 bytes (812 KB)
downloaded 812 KB

trying URL '
https://mirrors.dotsrc.org/cran/bin/windows/contrib/3.4/RODBCext_0.3.1.zip'
Content type 'application/zip' length 276687 bytes (270 KB)
downloaded 270 KB

package ?RODBC? successfully unpacked and MD5 sums checked
Warning: unable to move temporary installation
?C:\Users\PaulBernal\Documents\R\win-library\3.4\filedd64ac13805\RODBC? to
?C:\Users\PaulBernal\Documents\R\win-library\3.4\RODBC? # I dont understand
this Warning message I mean why was it unable to move a previous
installation?
package ?RODBCext? successfully unpacked and MD5 sums checked
Warning: unable to move temporary installation
?C:\Users\PaulBernal\Documents\R\win-library\3.4\filedd6447315795\RODBCext?
to ?C:\Users\PaulBernal\Documents\R\win-library\3.4\RODBCext?

The downloaded binary packages are in

C:\Users\PaulBernal\AppData\Local\Temp\Rtmpk7SkD5\downloaded_packages
Error in library("RODBC") : there is no package called ?RODBC?
Error in library("RODBCext") : there is no package called ?RODBCext?

If packages RODBC and RODBCext were successfully installed, why am I not
able to load those packages?

Any help will be greatly appreciated,

Paul
Bert Gunter
# 
I don't use Windows, but this looks like a Windows permissions issue, no?

You could try moving them yourself manually or create another library
directory that R can access to put them in.

... or wait and hope for advice from someone who uses Windows to give you a
definitive answer.

Cheers,
Bert



Bert Gunter

"The trouble with having an open mind is that people keep coming along and
sticking things into it."
-- Opus (aka Berkeley Breathed in his "Bloom County" comic strip )
On Tue, Sep 12, 2017 at 8:17 AM, Paul Bernal <paulbernal07 at gmail.com> wrote:

            

      
      
      
    

        

      
      
    

        

  
  


  


      

    

    

      
      

        


  

        

      Jeff Newmiller
    

    

      
      #
    

  


  

      
The messages tell you that the package files were successfully downloaded and extracted, but could not be added to the package library. Try making sure all instances of R are closed down before running the install.packages function. Also, just to be clear, avoid running R "As Administrator" under Windows unless you plan to fix the resulting mess yourself.

  
    

      
      
    

  


  


      

    

    

      
      

        


  

        

      Jeff Newmiller
    

    

      
      #
    

  


  

      
The messages tell you that the package files were successfully downloaded and extracted, but could not be added to the package library. Try making sure all instances of R are closed down before running the install.packages function. Also, just to be clear, avoid running R "As Administrator" under Windows unless you plan to fix the resulting mess yourself.