Yes I got the driver and it is working in Rstudio terminal entering SQL service account user id and password but not working using my DSN.
It is saying invalid user etc.
So when I am using Rstudio terminal using below connection detail it is working.
library(odbc)
library(RODBC)
con <- dbConnect(odbc(),Driver = "ODBC Driver 17 for SQL Server",Server = "VABSQLDWMRTD04\\Dvlp1,14415",Database = "B2B_Mgmt_Datamart_Dvlp",UID ="SAQ-R-B2B-T",PWD = rstudioapi::askForPassword("Database password"))
con <- dbConnect(odbc::odbc(), "MSSQL")