autstat Support

icon
Avatar
prgc21
Posts: 1
Have followed the installation steps to the letter: having first unistalled previous versions of R and the Home-and-Student version of REXCEL.

1) Installing R - Run as admin and set option to save version number in registry:

2) Run commands to install rcom and RSC Proxy in both 32 and 64bit version. Both times with R running as Admin. The only exception message I note is the final comRegisterRegistry() NULL message:

> options(install.packages.check.source = "no")
> install.packages(c("rscproxy","rcom"),repos="http://www.autstat.com/download",lib=.Library,type="win.binary")
trying URL 'http://www.autstat.com/download/bin/windows/contrib/3.3/rscproxy_2.1-2.zip'
Content type 'application/zip' length 70225 bytes (68 KB)
downloaded 68 KB
trying URL 'http://www.autstat.com/download/bin/windows/contrib/3.3/rcom_3.1-3.zip'
Content type 'application/zip' length 400985 bytes (391 KB)
downloaded 391 KB
package ‘rscproxy’ successfully unpacked and MD5 sums checked
package ‘rcom’ successfully unpacked and MD5 sums checked
The downloaded binary packages are in
C:\Users\paulc\AppData\Local\Temp\Rtmpaa7qKX\downloaded_packages
> library(rcom)
Loading required package: rscproxy
> comRegisterRegistry()
NULL
>[/b]


3) Installed DCOM 32 & 64 bit

4) Copied license File to relevant DCOM directories (replacing the installed RExcel.lic file, which was dated Feb 24. I renamed these .old):


5) Finally installed R-Excel:


I still get the message that No R-Server is configured:


When I check packages in R, rcom and rscproxy seem to be loading: the debug info on these is as follows:

attached base packages:


> R.Version()$version.string
[1] "R version 3.3.3 (2017-03-06)"
> sessionInfo()
R version 3.3.3 (2017-03-06)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows 10 x64 (build 14393)

locale:
[1] LC_COLLATE=English_United States.1252
[2] LC_CTYPE=English_United States.1252
[3] LC_MONETARY=English_United States.1252
[4] LC_NUMERIC=C
[5] LC_TIME=English_United States.1252

attached base packages:
[1] stats graphics grDevices utils datasets methods base
> installed.packages()["rscproxy",]
Package
"rscproxy"
LibPath
"C:/Users/paulc/OneDrive/Documents/R/win-library/3.3"
Version
"2.1-2"
Priority
NA
Depends
NA
Imports
NA
LinkingTo
NA
Suggests
NA
Enhances
NA
License
"statconnDCOM PUBLIC LICENSE"
License_is_FOSS
NA
License_restricts_use
NA
OS_type
NA
MD5sum
NA
NeedsCompilation
NA
Built
"3.3.0"
> installed.pwinverackages()["rcom",]


Am running Windows 10 (Version 1607 - OS Build 14393.953) and Office 360 (Excel 2016 MSO (16.0.7830.1018) 64 bit)

The message I get in Windows when I try to connect is:

"No R server configured. Please set R Server to work with RExcel"

Thanks for your help
2017-04-11 19:31
Avatar
Thomas Baier
Moderator
Posts: 221
Looks a bit strange for me. You said

iconprgc21:
Have followed the installation steps to the letter: having first unistalled previous versions of R and the Home-and-Student version of REXCEL.

2) Run commands to install rcom and RSC Proxy in both 32 and 64bit version. Both times with R running as Admin. The only exception message I note is the final comRegisterRegistry() NULL message:

> options(install.packages.check.source = "no")
> install.packages(c("rscproxy","rcom"),repos="http://www.autstat.com/download",lib=.Library,type="win.binary")
trying URL 'http://www.autstat.com/download/bin/windows/contrib/3.3/rscproxy_2.1-2.zip'
Content type 'application/zip' length 70225 bytes (68 KB)
downloaded 68 KB
trying URL 'http://www.autstat.com/download/bin/windows/contrib/3.3/rcom_3.1-3.zip'
Content type 'application/zip' length 400985 bytes (391 KB)
downloaded 391 KB
package ‘rscproxy’ successfully unpacked and MD5 sums checked
package ‘rcom’ successfully unpacked and MD5 sums checked
The downloaded binary packages are in
C:\Users\paulc\AppData\Local\Temp\Rtmpaa7qKX\downloaded_packages
> library(rcom)
Loading required package: rscproxy
> comRegisterRegistry()
NULL
>[/b]


and then

iconprgc21:

attached base packages:
[1] stats graphics grDevices utils datasets methods base
> installed.packages()["rscproxy",]
Package
"rscproxy"
LibPath
"C:/Users/paulc/OneDrive/Documents/R/win-library/3.3"
Version
"2.1-2"
Priority
NA
Depends
NA
Imports
NA
LinkingTo
NA
Suggests
NA
Enhances
NA
License
"statconnDCOM PUBLIC LICENSE"
License_is_FOSS
NA
License_restricts_use
NA
OS_type
NA
MD5sum
NA
NeedsCompilation
NA
Built
"3.3.0"
> installed.pwinverackages()["rcom",]


rscproxy should now be in your R installation directory, but instead is in your user library directory. Can you please check if there might both be a package rcom in your R installation directory (subdir library) and in your user library directory (c:/Users/paulc/OneDrive/Documentsw/R/win-library/3.3).


iconprgc21:

Am running Windows 10 (Version 1607 - OS Build 14393.953) and Office 360 (Excel 2016 MSO (16.0.7830.1018) 64 bit)

The message I get in Windows when I try to connect is:

"No R server configured. Please set R Server to work with RExcel"

Thanks for your help


Are you using foreground or background server? In either case, can you please provide a DebugView log file created while connecting to R from RExcel.

Thomas
2017-04-12 00:03
icon