Good day all. I am having same issue described here after deploying shiny app to server, I keep getting same error 'Data source name not found, and no default driver specified'
find below sql odbc connection. sql_script is my input variable. I first created a data source name using an 'odbc data source connection 64 bit' on my computer system before running the code on R console.
However, it worked when I first deployed it but stopped working after a while.
Please how do I go about this?
#SQL_DB_CONNECTION
con=odbcConnect("dsn",uid="xxxxx", pwd="xxxxxxxxxx")
on.exit(odbcClose(con))
sql_db=sqlQuery(con,sql_script)