I have an issue with my Shiny application, i use data from a HFSQL database so i connected the app to my databse with ODBC.
con <- odbcConnect("HFSQLdb")
My app is working locally but after i deploy it it says on logs :
Warning in RODBC::odbcDriverConnect("DSN=HFSQLdb")
[RODBC] ERROR: state IM002, code 0, message [unixODBC][Driver Manager]Data source name not found, and no default driver specified
Warning in RODBC::odbcDriverConnect("DSN=HFSQLdb") :
ODBC connection failed
Also after i deploy the app i get this message, not sure if it matters :
Application successfully deployed to ...
Error detecting locale: Error in read.table(file = file, header = header, sep = sep, quote = quote, : ligne finale incomplète trouvée par readTableHeader dans 'raw'
(Using default: en_US)
Online im disconnected from the server and there is a reload button.
As i said it works locally so i dont understand why it does that.