When I deploy to shinyapps.io, it gives me an error:
Unable to find repository URL for package RODBC
So when I go to open the chart via URL, it doesn't show anything, because it was unable to connect to the connection I had and load the data into the data frames I had created.
Deploy information:
The package is installed and works normally, even I search the data in my database through it.
As I didn't use this community before, I also posted this question on [Stack Overflow].(https://stackoverflow.com/questions/62516651/r-unable-to-find-repository-for-package-rodbc-when-deploying?noredirect=1#comment110559609_62516651)
what do you get when you type
getOption("repos")
into the R console there ?
oh and also
sessionInfo()
@nirgrahamuk results below:
> getOption("repos")
CRAN
"https://cran.rstudio.com/"
attr(,"RStudio")
[1] TRUE
> sessionInfo()
R version 3.6.1 (2019-07-05)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows 10 x64 (build 18363)
Matrix products: default
locale:
[1] LC_COLLATE=Portuguese_Brazil.1252 LC_CTYPE=Portuguese_Brazil.1252
[3] LC_MONETARY=Portuguese_Brazil.1252 LC_NUMERIC=C
[5] LC_TIME=Portuguese_Brazil.1252
attached base packages:
[1] stats graphics grDevices utils datasets methods base
loaded via a namespace (and not attached):
[1] compiler_3.6.1 rsconnect_0.8.16 tools_3.6.1 curl_4.3 jsonlite_1.6.1
[6] digest_0.6.25 openssl_1.4.1 askpass_1.1
ok, you have R version 3.6.1
so packages needing R4 wont work (unless you upgrade your R)
https://cran.r-project.org/web/packages/RODBC/ChangeLog
says that R4 is required since Version: 1.3-17 (2020-05-11, released)
you'd be able to install Version: 1.3-16 (2019-09-02, released) if you stick with your R version.
you can either find an MRAN mirror , or perhaps use renv package to install 1.3.16
If you had renv you would do
renv::install("RODBC", type = "binary")
I'm still on R 3.6.2 myself, and this is the result:
Retrieving 'https://cran.rstudio.com/bin/windows/contrib/3.6/RODBC_1.3-16.zip' ...
OK [file is up to date]
Installing RODBC [1.3-16] ...
OK [installed binary]
* Copying 'RODBC' into the cache ... Done!
@nirgrahamuk, Although my project is not working yet at shinyapps.io (I don't know why, I'm checking the log), the problem was solved as you explained!
I ended up updating the R version, and the error didn't show up anymore, thanks! I didn't know that it was necessary to update the version for this kind of problem!