I connected a DB with this code:
con <- DBI::dbConnect(odbc::odbc(), Driver = "ODBC Driver 17 for SQL Server", Database = "***", Server = "***", UID = "***", PWD = "****", Port = 1433)
and I created a DF with dbGetQuery.
When I deploy this app to Shiny, I get this error:
Warning: Error in : nanodbc/nanodbc.cpp:983: 00000: [unixODBC][Driver Manager]Data source name not found, and no default driver specified