Unable to find repository for package RODBC when deploying

[guimatheus92]

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].(shiny - R unable to find repository for package RODBC when deploying - Stack Overflow)

[nirgrahamuk]

what do you get when you type

getOption("repos")

into the R console there ?
oh and also

sessionInfo()

[guimatheus92]

@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 

[nirgrahamuk]

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!

[guimatheus92]

@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!