install.packages('odbc')
install.packages('rstudioapi')
library(odbc)
library(rstudioapi)
con <- dbConnect(odbc(),
Driver = "SQL Server",
Server = "192.168.xxx.xxx",
Database = "xxx",
UID = "xxx",
PWD = rstudioapi::askForPassword("xxx"),
Port = 1433)
tes <- dbGetQuery(con,'select * from bem.dbo.JardineLending')
