connectMsSqlSqlLogin: Connects an R session to a running instance of Microsoft SQL...

In nathan-palmer/MsSqlTools: Convenience wrapper functions to establish ODBC connections to SQL Server

Connects an R session to a running instance of Microsoft SQL Server using SQL Server login credentials over ODBC.

Description

Connects an R session to a running instance of Microsoft SQL Server using SQL Server login credentials over ODBC.

Usage

connectMsSqlSqlLogin(server, user, password, database, port = 1433,
  driver = c("ODBC Driver 17 for SQL Server", "FreeTDS"),
  tdsVersion = "8.0")

Arguments

server	The network address of the Windows instance that is running SQL Server.
user	The SQL Server user name.
password	The password for the SQl Server user.
database	The name of the database on the server that you want to connect to.
port	The TCP port that SQL Server is listening on.
driver	The name of an installed ODBC driver to use for the connection. Current supported options are "FreeTDS" and "ODBC Driver 17 for SQL Server"
tdsVersion	The TDS protocol version to use for the connection.

nathan-palmer/MsSqlTools documentation built on July 2, 2022, 7:17 p.m.