autstat Support

icon
Avatar
larry_rave
Posts: 9
Dear Thomas,

as you suggested I am moving the discussion here.

I have R 3.4 installed. I have now managed to get rscproxy and rcom installed in the suitable directory. I have downloaded and installed the latest statconn.

When I go and run Rexcel 3.2.16, during the installation it seems to look for a R.2.13 version of the software, which I have removed as some packages are no longer compatible.

As a result, although the Rexcel option appears in the excel ribbon, it does not manage to connect to the R 3.4 version of the software.

Any suggestions?

Thanks,

Larry
2017-11-09 14:58
Avatar
Thomas Baier
Moderator
Posts: 221
Dear Larry,

if you are looking for help with RExcel, please ask on the mailing list rcom-l.

If you think the problem is due to an installation issue with statconnDCOM, please post the appropriate information (see http://autstat.com/index.php/Support/topic/23.html)

Best regards,
Thomas
2017-11-09 15:10
Avatar
larry_rave
Posts: 9
Dear Thomas, here is the info.

Thanks,

Larry

R.Version()$version.string
[1] "R version 3.4.2 (2017-09-28)"
> sessionInfo()
R version 3.4.2 (2017-09-28)
Platform: i386-w64-mingw32/i386 (32-bit)
Running under: Windows 8.1 x64 (build 9600)

Matrix products: default

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

attached base packages:
[1] stats graphics grDevices utils datasets methods base

other attached packages:
[1] rcom_3.1-5 rscproxy_2.1-3

loaded via a namespace (and not attached):
[1] compiler_3.4.2
> installed.packages()["rscproxy",]
Package LibPath
"rscproxy" "C:/R/library"
Version Priority
"2.1-3" NA
Depends Imports
NA NA
LinkingTo Suggests
NA NA
Enhances License
NA "statconnDCOM PUBLIC LICENSE"
License_is_FOSS License_restricts_use
NA NA
OS_type MD5sum
NA NA
NeedsCompilation Built
NA "3.4.0"
> installed.packages()["rcom",]
Package LibPath
"rcom" "C:/R/library"
Version Priority
"3.1-5" NA
Depends Imports
"R (>= 3.3.0), rscproxy (>= 2.1-1), utils" NA
LinkingTo Suggests
"rscproxy" NA
Enhances License
NA "file LICENSE"
License_is_FOSS License_restricts_use
NA NA
OS_type MD5sum
"windows" NA
NeedsCompilation Built
NA "3.4.0"



[2380] statconnDCOM Installation path is "C:\R\statconn\DCOM"
[2380] BDXImpl_init(licensee=Testing, connector=R, parameters=(null), objptr=0064BDF4, installpath=C:\R\statconn\DCOM, licensepath=C:\R\statconn\DCOM
[2380] BDX_get_vtbl2: conn=R, licensee=Testing, objptr=0040B6A0, version=1, path=C:\R\statconn\DCOM
[2380] BDX: DateTime enabled
[2380] BDX: Special .NET features enabled
[2380] BDX: x86 support (32bit) enabled
[2380] BDX: x64 support (64bit) enabled
[2380] H&S: Closing Splash Screen
[2380] ~SplashImpl
[2380] CStatConnector::initBDXForConnector() vtbl-object@1007B000
[2380] connector: R
[2380] DLL: rscproxy.dll
[2380] environment: R_HOME
[2380] registry key: Software\R-core\R
[2380] registry value: InstallPath
[2380] version key:
[2380] version value:
[2380] binary dir: bin/i386
[2380] connector: RPre2.12
[2380] DLL: rscproxy.dll
[2380] environment: R_HOME
[2380] registry key: Software\R-core\R
[2380] registry value: InstallPath
[2380] version key:
[2380] version value:
[2380] binary dir: bin
[2380] connector: Rold
[2380] DLL: rproxy.dll
[2380] environment: R_HOME
[2380] registry key: Software\R-core\R
[2380] registry value: InstallPath
[2380] version key:
[2380] version value:
[2380] binary dir: bin
[2380] connector: SciLab
[2380] DLL: sciproxy.dll
[2380] environment: SCILAB_HOME
[2380] registry key: Software\Scilab\%s
[2380] registry value: SCIPATH
[2380] version key: Software\Scilab
[2380] version value: LASTINSTALL
[2380] binary dir: bin
[2380] sc_proxy_find_connector: found "R"
[2380] sc_proxy_find_connector: found "R"
[2380] sc_proxy_load log follows!
[2380] sc_proxy_load: sc_proxy_find_connector(,<R>) done
[2380] sc_proxy_load: sc_proxy_find_connector(,<R>) done
[2380] Look up "R" in the registry
[2380] sc_proxy_load: use registry key "Software\R-core\R"
[2380] looking up registry key at "HKCU\Software\R-core\R\InstallPath"
[2380] looking up registry key at "HKLM\Software\R-core\R\InstallPath"
[2380] adding <C:\R\R-2.15.3\bin/i386> to path <C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\>
[2380] new path is C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\R\R-2.15.3\bin/i386
[2380] No Debugging of rproxy
[2380] rscproxy> R.DLL version is 3.0.0, expected 2.15.3 (3!=2)
[2380] CStatConnector::~CStatConnector()
[4204] statconnDCOM Installation path is "C:\R\statconn\DCOM"
[4204] BDXImpl_init(licensee=Home and student, connector=R, parameters=(null), objptr=00588014, installpath=C:\R\statconn\DCOM, licensepath=C:\R\statconn\DCOM
[4204] BDX_get_vtbl2: conn=R, licensee=Home and student, objptr=0040B6A0, version=1, path=C:\R\statconn\DCOM
[4204] BDX_get_vtbl2: error 0 loading license file for "Home and student"
[4204] CStatConnector::initBDXForConnector() vtbl-object@00000000
[4204] CStatConnector::~CStatConnector()
[2592] statconnDCOM Installation path is "C:\R\statconn\DCOM"
[2592] BDXImpl_init(licensee=Testing, connector=R, parameters=(null), objptr=00679F24, installpath=C:\R\statconn\DCOM, licensepath=C:\R\statconn\DCOM
[2592] BDX_get_vtbl2: conn=R, licensee=Testing, objptr=0040B6A0, version=1, path=C:\R\statconn\DCOM
[2592] BDX: DateTime enabled
[2592] BDX: Special .NET features enabled
[2592] BDX: x86 support (32bit) enabled
[2592] BDX: x64 support (64bit) enabled
[2592] H&S: Closing Splash Screen
[2592] ~SplashImpl
[2592] CStatConnector::initBDXForConnector() vtbl-object@1007B000
[2592] connector: R
[2592] DLL: rscproxy.dll
[2592] environment: R_HOME
[2592] registry key: Software\R-core\R
[2592] registry value: InstallPath
[2592] version key:
[2592] version value:
[2592] binary dir: bin/i386
[2592] connector: RPre2.12
[2592] DLL: rscproxy.dll
[2592] environment: R_HOME
[2592] registry key: Software\R-core\R
[2592] registry value: InstallPath
[2592] version key:
[2592] version value:
[2592] binary dir: bin
[2592] connector: Rold
[2592] DLL: rproxy.dll
[2592] environment: R_HOME
[2592] registry key: Software\R-core\R
[2592] registry value: InstallPath
[2592] version key:
[2592] version value:
[2592] binary dir: bin
[2592] connector: SciLab
[2592] DLL: sciproxy.dll
[2592] environment: SCILAB_HOME
[2592] registry key: Software\Scilab\%s
[2592] registry value: SCIPATH
[2592] version key: Software\Scilab
[2592] version value: LASTINSTALL
[2592] binary dir: bin
[2592] sc_proxy_find_connector: found "R"
[2592] sc_proxy_find_connector: found "R"
[2592] sc_proxy_load log follows!
[2592] sc_proxy_load: sc_proxy_find_connector(,<R>) done
[2592] sc_proxy_load: sc_proxy_find_connector(,<R>) done
[2592] Look up "R" in the registry
[2592] sc_proxy_load: use registry key "Software\R-core\R"
[2592] looking up registry key at "HKCU\Software\R-core\R\InstallPath"
[2592] looking up registry key at "HKLM\Software\R-core\R\InstallPath"
[2592] adding <C:\R\R-2.15.3\bin/i386> to path <C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\>
[2592] new path is C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\R\R-2.15.3\bin/i386
[2592] No Debugging of rproxy
[2592] rscproxy> R.DLL version is 3.0.0, expected 2.15.3 (3!=2)
[2592] CStatConnector::~CStatConnector()
[6504] statconnDCOM Installation path is "C:\R\statconn\DCOM"
[6504] BDXImpl_init(licensee=Testing, connector=R, parameters=(null), objptr=005D903C, installpath=C:\R\statconn\DCOM, licensepath=C:\R\statconn\DCOM
[6504] BDX_get_vtbl2: conn=R, licensee=Testing, objptr=0040B6A0, version=1, path=C:\R\statconn\DCOM
[6504] BDX: DateTime enabled
[6504] BDX: Special .NET features enabled
[6504] BDX: x86 support (32bit) enabled
[6504] BDX: x64 support (64bit) enabled
[6504] H&S: Closing Splash Screen
[6504] ~SplashImpl
[6504] CStatConnector::initBDXForConnector() vtbl-object@1007B000
[6504] connector: R
[6504] DLL: rscproxy.dll
[6504] environment: R_HOME
[6504] registry key: Software\R-core\R
[6504] registry value: InstallPath
[6504] version key:
[6504] version value:
[6504] binary dir: bin/i386
[6504] connector: RPre2.12
[6504] DLL: rscproxy.dll
[6504] environment: R_HOME
[6504] registry key: Software\R-core\R
[6504] registry value: InstallPath
[6504] version key:
[6504] version value:
[6504] binary dir: bin
[6504] connector: Rold
[6504] DLL: rproxy.dll
[6504] environment: R_HOME
[6504] registry key: Software\R-core\R
[6504] registry value: InstallPath
[6504] version key:
[6504] version value:
[6504] binary dir: bin
[6504] connector: SciLab
[6504] DLL: sciproxy.dll
[6504] environment: SCILAB_HOME
[6504] registry key: Software\Scilab\%s
[6504] registry value: SCIPATH
[6504] version key: Software\Scilab
[6504] version value: LASTINSTALL
[6504] binary dir: bin
[6504] sc_proxy_find_connector: found "R"
[6504] sc_proxy_find_connector: found "R"
[6504] sc_proxy_load log follows!
[6504] sc_proxy_load: sc_proxy_find_connector(,<R>) done
[6504] sc_proxy_load: sc_proxy_find_connector(,<R>) done
[6504] Look up "R" in the registry
[6504] sc_proxy_load: use registry key "Software\R-core\R"
[6504] looking up registry key at "HKCU\Software\R-core\R\InstallPath"
[6504] looking up registry key at "HKLM\Software\R-core\R\InstallPath"
[6504] adding <C:\R\R-2.15.3\bin/i386> to path <C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\>
[6504] new path is C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\R\R-2.15.3\bin/i386
[6504] No Debugging of rproxy
[6504] rscproxy> R.DLL version is 3.0.0, expected 2.15.3 (3!=2)
[6504] CStatConnector::~CStatConnector()
2017-11-10 11:07
Avatar
Thomas Baier
Moderator
Posts: 221
The registry says, that the current R version is installed in "C:\R\R-2.15.3"

Maybe you forgot to add version information to the registry when installing the new version of R
2017-11-10 18:55
Avatar
larry_rave
Posts: 9
Understood, will do, thanks

Larry
2017-11-11 10:54
Avatar
larry_rave
Posts: 9
It appears that some of the issues arise due to the various versions of R installed on my machine. I need 3.4 for having access to some of the latest packages. I have tried eliminating R 2.13 altogether but the latest Rexcel installer as downloaded here does not find a correct R version in the registry. I am not sure I can play around in the registry by myself.

If I remove all versions of R and related softwares and reinstall from scratch, do you think it might work?

Thanks again,

Larry
2017-11-11 15:13
Avatar
Thomas Baier
Moderator
Posts: 221
I'm sorry, but I cannot help you concerning RExcel.

For statconn Excel it would be enough to run RSetReg.exe on the R version you want to use.
2017-11-11 18:15
Avatar
larry_rave
Posts: 9
I did as you suggested and everything works now.

Thanks a lot for your help!

Larry
2017-11-13 09:45
icon