Shiny app deployed but not working ( ODBC HFSQL Database not connected )

[Arthur]

Hello,

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.

[andresrcs]

@Arthur

con <- odbcConnect("HFSQLdb")

My app is working locally

You have the DSN defined in your local environment, that is why you can simply call it by name, but that DSN is not defined on the shinyapps.io servers so you need to specify the connection parameters like which driver to use, the server ip, your credentials, etc.

Also, please be aware of our cross-posting policy

https://stackoverflow.com/questions/74210574/shiny-app-isnt-working-with-odbc-data-base-connection-after-being-deployed

FAQ: Is it OK if I cross-post?

Posting the same question both here and on other sites Posting the same question to multiple forums at the same time is often considered impolite. We don't completely ban such cross-posting, but we ask you to think hard before you do it and to follow some rules. Cross-post sparingly Rather than post the same thing here and elsewhere from the get-go, post in one place at a time. Let enough time go by (think days, not hours) before you take your question somewhere else. Sometimes people at another site may suggest you post here if your question doesn't fit within the scope of the other site. Always link to your other posts, and update everywhere with any solution…

[Arthur]

Yes i read that too before asking for help, but i can't connect to my database without the DSN.
I tried :

odbcDriverConnect('driver=HFSQL;server=ipserver;database=dbname;uid=username;pwd=password;port=port')

and i get

Warning in odbcDriverConnect( odbcDriverConnect('driver=HFSQL;server=ipserver;database=dbname;uid=username;pwd=password;port=port'))
[RODBC] ERROR: state S1000, code 0, message Unable to connect: the connection string is insufficient

Sorry about cross posting i didnt know about that

[andresrcs]

@Arthur

driver=HFSQ

I'm not familiar with HFSQ but I think there is no driver for it on shinyapps.io, at least not a specific one. I might be wrong though.

@Arthur

Sorry about cross posting i didnt know about that

It is OK to cross post as long as you follow the guidelines.

[Arthur]

The problem is i can't even connect Rstudio to my HFSQL data base without the DSN, it's just not working, i tried so many things.