razure-dsvm

DSVM - Visual Studio - R - cannot use an installed package


I am running an R script on Visual Studio in a DSVM. I ran into a problem installing a package (RODBC) that was already installed. I get this message:

package 'RODBC' successfully unpacked and MD5 sums checked Warning: cannot remove prior installation of package 'RODBC'

And if I try to load the library I get the message that it doesn’t exist.

Error in base::library(...): there is no package called 'RODBC'

In package manager it’s available but not installed.

But in the library path, in file explorer, the package is there and I cannot delete it – always get the message that the folder is in use even if VS is closed. I tried changing the permissions to full control and still no luck.

Please let me know if you have any suggestion on how to fix this problem. Many thanks.


Solution

  • Please check the R tools for Visual Studio (RTVS) options and see if the R Engine (64 bit) setting is empty. If it is empty, you need to set it to the directory where the Microsoft R (or ML Server on latest Windows 2016 edition of DSVM ) is installed.