connecting to SQL Server external vs local

sqlserver.R

# production 
dbConnect(
  RSQLServer::SQLServer(),
  server = config$server,
  database = config$database,
  properties = list(
    user = config$uid,
    password = config$pwd
  )
)

# local
# 'server' changes to 'Server'
# 'database' changes to 'Database'
# properties isn't required
# Driver is required
# drv is different
dbConnect(
  odbc::odbc(),
  Driver = "{SQL Server}",
  Server = config$server,
  Database = config$database
)