Unable to load packages RODBC and RODBCext in R

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Unable to load packages RODBC and RODBCext in R

PaulJr
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:

> install.packages("RODBCext")
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

> library("RODBC")
Error in library("RODBC") : there is no package called ‘RODBC’

> library("RODBCext")
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

        [[alternative HTML version deleted]]

______________________________________________
[hidden email] 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.
Reply | Threaded
Open this post in threaded view
|

Re: Unable to load packages RODBC and RODBCext in R

Bert Gunter-2
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 <[hidden email]> wrote:

> 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:
>
> > install.packages("RODBCext")
> 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
>
> > library("RODBC")
> Error in library("RODBC") : there is no package called ‘RODBC’
>
> > library("RODBCext")
> 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
>
>         [[alternative HTML version deleted]]
>
> ______________________________________________
> [hidden email] 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]]

______________________________________________
[hidden email] 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.
Reply | Threaded
Open this post in threaded view
|

Re: Unable to load packages RODBC and RODBCext in R

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.
--
Sent from my phone. Please excuse my brevity.

On September 12, 2017 10:58:14 AM PDT, Bert Gunter <[hidden email]> wrote:

>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 <[hidden email]>
>wrote:
>
>> 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:
>>
>> > install.packages("RODBCext")
>> 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
>>
>> > library("RODBC")
>> Error in library("RODBC") : there is no package called ‘RODBC’
>>
>> > library("RODBCext")
>> 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
>>
>>         [[alternative HTML version deleted]]
>>
>> ______________________________________________
>> [hidden email] 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]]
>
>______________________________________________
>[hidden email] 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.

______________________________________________
[hidden email] 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.
Reply | Threaded
Open this post in threaded view
|

Re: Unable to load packages RODBC and RODBCext in R

Jeff Newmiller
In reply to this post by Bert Gunter-2
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.
--
Sent from my phone. Please excuse my brevity.

On September 12, 2017 10:58:14 AM PDT, Bert Gunter <[hidden email]> wrote:

>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 <[hidden email]>
>wrote:
>
>> 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:
>>
>> > install.packages("RODBCext")
>> 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
>>
>> > library("RODBC")
>> Error in library("RODBC") : there is no package called ‘RODBC’
>>
>> > library("RODBCext")
>> 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
>>
>>         [[alternative HTML version deleted]]
>>
>> ______________________________________________
>> [hidden email] 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]]
>
>______________________________________________
>[hidden email] 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.

______________________________________________
[hidden email] 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.