Problem with sql data and r shiny app

[Kimse]

I am having trouble connecting SQL with my r shiny app. It loads fine in Rstudio, but return "disconnected from server. Reload" when publishing to shinyapps.io. Does anyone know what im doing wrong?

library(shiny)
##library(DT)
library(odbc)
library(DBI)


################# ui #####################

ui <- fluidPage(
  plotOutput("plot1", click = "plot_click"),
  verbatimTextOutput("info")
)

################# end ui #####################

################# server #####################

server <- function(input, output) {
  
  con <- dbConnect(odbc(),
                   Driver = "SQL Server",
                   Server = "DESKTOP-7129D7L",
                   Database = "Kim",
                   Trusted_Connection = "True")
  
  query <- dbGetQuery(con, "SELECT Date,FieldValue,FieldTicker
  FROM data WHERE FieldTicker='^VIX' order by date asc")
  query$Date <- as.Date(query$Date)
  
  output$plot1 <- renderPlot({
    plot(FieldValue ~ Date, query,type="l",ylab = "",xlab="")
  })
  
  output$info <- renderText({
    paste0("x=", input$plot_click$x, "\ny=", input$plot_click$y)
  })
}
################# end server #####################

shinyApp(ui,server)

log:
2020-11-21T09:19:50.661181+00:00 shinyapps[3134369]: Running on host: 9ac1790e1901
2020-11-21T09:19:50.666668+00:00 shinyapps[3134369]: Server version: 1.8.4.1-20
2020-11-21T09:19:50.666678+00:00 shinyapps[3134369]: LANG: en_US.UTF-8
2020-11-21T09:19:50.666707+00:00 shinyapps[3134369]: R version: 3.6.3
2020-11-21T09:19:50.666717+00:00 shinyapps[3134369]: shiny version: 1.5.0
2020-11-21T09:19:50.666744+00:00 shinyapps[3134369]: httpuv version: 1.5.4
2020-11-21T09:19:50.666763+00:00 shinyapps[3134369]: rmarkdown version: (none)
2020-11-21T09:19:50.666774+00:00 shinyapps[3134369]: jsonlite version: 1.7.0
2020-11-21T09:19:50.666763+00:00 shinyapps[3134369]: knitr version: (none)
2020-11-21T09:19:50.666956+00:00 shinyapps[3134369]: Using pandoc: /opt/connect/ext/pandoc2
2020-11-21T09:19:50.837294+00:00 shinyapps[3134369]: Using jsonlite for JSON processing
2020-11-21T09:19:50.840233+00:00 shinyapps[3134369]:
2020-11-21T09:19:50.840234+00:00 shinyapps[3134369]: Starting R with process ID: '388'
2020-11-21T09:19:50.666793+00:00 shinyapps[3134369]: RJSONIO version: (none)
2020-11-21T09:19:50.666844+00:00 shinyapps[3134369]: htmltools version: 0.5.0
2020-11-21T09:19:51.100620+00:00 shinyapps[3134369]:
2020-11-21T09:19:51.100622+00:00 shinyapps[3134369]: Listening on http://127.0.0.1:40583
2020-11-21T09:19:52.703502+00:00 shinyapps[3134369]: Warning: Error in : nanodbc/nanodbc.cpp:1021: 00000: [unixODBC][Driver Manager]Can't open lib 'SQL Server' : file not found
2020-11-21T09:19:52.713369+00:00 shinyapps[3134369]: 66:
2020-11-21T09:19:52.713438+00:00 shinyapps[3134369]: Error : nanodbc/nanodbc.cpp:1021: 00000: [unixODBC][Driver Manager]Can't open lib 'SQL Server' : file not found