Question : r dbConnect(odbc::odbc() to ms sql server remote
Answered by : xenophobic-xenomorph-r6izowgq78jp
library(odbc)con <- dbConnect(odbc(), Driver = "SQLServer", Server = "mysqlhost", Database = "mydbname", UID = "myuser", PWD = rstudioapi::askForPassword("Database password") Port = 1433)
Source : https://support.rstudio.com/hc/en-us/articles/214510788-Setting-up-R-to-connect-to-SQL-Server- | Last Update : Tue, 16 Feb 21