I use the ODBC package to develop an Shiny app which runs fine on RStudio Online.
then I try to deploy it on our internal instance of RConnect, I get this error
unable to load shared object '/opt/rstudio-connect/mnt/packrat/4.0.3/v2/library/odbc/1fa16c2d82b39184818570103dd40fae/odbc/libs/odbc.so'
When building the ODBC Driver string (to SQL Server) I have used this alias {ODBC Driver 17 for SQL Server} it looks like this alias points to the above .so file on RConnect but it isn't allowing it work.
Is it an admin issue? Can the admin just somehow allow access to the folder then it should work?