Search notes:

R: package odbc and SQL Server

R DBI, ODBC and SQL Server data types

Determine the used DLL of driver

With dbGetInfo, it's possible to determine the DLL that is used for the ODBC connection. It is sqlsrv32.dll.
library(odbc)

sqlServer <- dbConnect(odbc(),
          driver   = "SQL Server" ,
          server   = Sys.getenv("COMPUTERNAME"),
          database ='tq84_db'
);

dbGetInfo(sqlServer)$drivername;
#
#  "SQLSRV32.DLL"
Github repository about-r, path: /packages/odbc/SQLServer/drivername.R

See also

R package odbc.

Index