My R shiny application works locally but after I deploy it I get the error in logs :
2022-10-26T14:31:25.572430+00:00 shinyapps[7427210]: Warning in RODBC::odbcDriverConnect("DSN=HFSQLdb") :
2022-10-26T14:31:25.572461+00:00 shinyapps[7427210]: ODBC connection failed
2022-10-26T14:31:25.606372+00:00 shinyapps[7427210]: Warning: Error in sqlQuery: first argument is not an open RODBC channel
My application is using data from a HFSQL data base which im connected with an ODBC DNS.
Here is my code which is working locally (server.R)
server <- function(input, output) {
con <- odbcConnect("HFSQLdb")
sql <- "mysqlrequest"
data<-sqlQuery(con,sql)
....
})
Then when my app is running online im disconnected from the server with a reload button.
Not sure what i can do to make the app work online..
