Cannot Publish To Shinyapps.io - nanodbc driver error and unable to find repo URLs

Posit Professional & Hosted Products shinyapps.io
1

I am having a hard time deploying my application to shinyappsio.

It deploys fine locally, but once I push it to my shinyapps.io account, it errors out and just tells me to refer to the logs. This is what it tells me (sorry it's long):

2021-03-31T18:46:06.900110+00:00 shinyapps[3888130]: 
2021-03-31T18:46:06.900788+00:00 shinyapps[3888130]: The following objects are masked from ‘package:methods’:
2021-03-31T18:46:06.900789+00:00 shinyapps[3888130]: 
2021-03-31T18:46:06.900110+00:00 shinyapps[3888130]:     runExample
2021-03-31T18:46:06.900789+00:00 shinyapps[3888130]:     removeClass, show
2021-03-31T18:46:06.900790+00:00 shinyapps[3888130]: 
2021-03-31T18:46:06.915120+00:00 shinyapps[3888130]: Welcome to clipr. See ?write_clip for advisories on writing to the clipboard in R.
2021-03-31T18:46:06.990046+00:00 shinyapps[3888130]: 
2021-03-31T18:46:06.990048+00:00 shinyapps[3888130]: Attaching package: ‘readr’
2021-03-31T18:46:06.990049+00:00 shinyapps[3888130]: 
2021-03-31T18:46:06.990499+00:00 shinyapps[3888130]: The following object is masked from ‘package:rvest’:
2021-03-31T18:46:06.990501+00:00 shinyapps[3888130]:     guess_encoding
2021-03-31T18:46:06.990500+00:00 shinyapps[3888130]: 
2021-03-31T18:46:06.990501+00:00 shinyapps[3888130]: 
2021-03-31T18:46:07.032711+00:00 shinyapps[3888130]: Loading required package: RMySQL
2021-03-31T18:46:07.108150+00:00 shinyapps[3888130]: Loading required package: gWidgets
2021-03-31T18:46:07.363167+00:00 shinyapps[3888130]: 
2021-03-31T18:46:07.363169+00:00 shinyapps[3888130]: Attaching package: ‘gWidgets’
2021-03-31T18:46:07.363170+00:00 shinyapps[3888130]: 
2021-03-31T18:46:07.363719+00:00 shinyapps[3888130]:     id
2021-03-31T18:46:07.490839+00:00 shinyapps[3888130]: 
2021-03-31T18:46:07.363719+00:00 shinyapps[3888130]: 
2021-03-31T18:46:07.491253+00:00 shinyapps[3888130]: 
2021-03-31T18:46:07.364666+00:00 shinyapps[3888130]: The following object is masked from ‘package:shiny’:
2021-03-31T18:46:07.364667+00:00 shinyapps[3888130]: 
2021-03-31T18:46:07.491251+00:00 shinyapps[3888130]: The following object is masked from ‘package:shinyjs’:
2021-03-31T18:46:07.364667+00:00 shinyapps[3888130]:     tag
2021-03-31T18:46:07.363719+00:00 shinyapps[3888130]: 
2021-03-31T18:46:07.363718+00:00 shinyapps[3888130]: The following object is masked from ‘package:dplyr’:
2021-03-31T18:46:07.364668+00:00 shinyapps[3888130]: 
2021-03-31T18:46:07.490841+00:00 shinyapps[3888130]: Attaching package: ‘shinyWidgets’
2021-03-31T18:46:07.491252+00:00 shinyapps[3888130]: 
2021-03-31T18:46:07.490842+00:00 shinyapps[3888130]: 
2021-03-31T18:46:07.491252+00:00 shinyapps[3888130]:     alert
2021-03-31T18:46:07.863014+00:00 shinyapps[3888130]: ── Attaching packages ─────────────────────────────────────── tidyverse 1.3.0 ──
2021-03-31T18:46:07.866675+00:00 shinyapps[3888130]: ✔ tibble  3.1.0     ✔ forcats 0.5.1
2021-03-31T18:46:08.021543+00:00 shinyapps[3888130]: ✖ dplyr::collapse()       masks nlme::collapse()
2021-03-31T18:46:08.021544+00:00 shinyapps[3888130]: ✖ tibble::data_frame()    masks dplyr::data_frame(), vctrs::data_frame()
2021-03-31T18:46:08.021541+00:00 shinyapps[3888130]: ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
2021-03-31T18:46:08.021542+00:00 shinyapps[3888130]: ✖ data.table::between()   masks dplyr::between()
2021-03-31T18:46:08.041638+00:00 shinyapps[3888130]:   93: <Anonymous>
2021-03-31T18:46:08.021544+00:00 shinyapps[3888130]: ✖ dplyr::filter()         masks plotly::filter(), stats::filter()
2021-03-31T18:46:08.021544+00:00 shinyapps[3888130]: ✖ data.table::first()     masks dplyr::first()
2021-03-31T18:46:08.021546+00:00 shinyapps[3888130]: ✖ data.table::last()      masks dplyr::last()
2021-03-31T18:46:08.021545+00:00 shinyapps[3888130]: ✖ dplyr::group_rows()     masks kableExtra::group_rows()
2021-03-31T18:46:08.037558+00:00 shinyapps[3888130]: Warning: Error in : nanodbc/nanodbc.cpp:1021: 00000: [unixODBC][Driver Manager]Data source name not found, and no default driver specified 
2021-03-31T18:46:08.021547+00:00 shinyapps[3888130]: ✖ data.table::transpose() masks purrr::transpose()
2021-03-31T18:46:08.021545+00:00 shinyapps[3888130]: ✖ readr::guess_encoding() masks rvest::guess_encoding()
2021-03-31T18:46:08.021546+00:00 shinyapps[3888130]: ✖ gWidgets::id()          masks dplyr::id()
2021-03-31T18:46:08.021546+00:00 shinyapps[3888130]: ✖ dplyr::lag()            masks stats::lag()
2021-03-31T18:46:08.021547+00:00 shinyapps[3888130]: ✖ purrr::modify()         masks renv::modify()

Also printed in my RStudio Console are these warnings:

Warning in FUN(X[[i]], ...) : Unable to find repository URL for package Matrix Warning in FUN(X[[i]], ...) : Unable to find repository URL for package dbConnect Warning in FUN(X[[i]], ...) : Unable to find repository URL for package gWidgets Warning in FUN(X[[i]], ...) : Unable to find repository URL for package mgcv

Some additional context:

  1. I am deploying this by publishing a ui.R/server.R set up
  2. The version of R I am using is 3.4.4 (and sorry, I cannot update this to the latest version because I have some other software that relies upon 3.4.4 version, so I do have some package dependencies that need to be compatible with this older version or have reverse compatibility)
  3. One of the scripts used by the application does connect to a local postgresql database on a Windows 10 64bit system. I am using the dbConnect library to establish the connection to the database and then I use dbDisconnect()to close the connection after the data object has been created and saved.

Given the above and my specific situation, is there any way to get this to deploy on shinyapps.io?