connect_db: Connect Function

In mssqlR: MSSQL Querying using R

Description

This function allows you to connect to a MS SqlServer Database

Usage

connect_db(server, db, uid, pwd)

Arguments

server	Database Server Url/IP Address
db	Database Name
uid	User id
pwd	Password

Examples

dbHandle <- connect_db("server.com","db_test","admin","password")

Example output

Warning messages:
1: In odbcDriverConnect(paste("driver={SQL Server Native Client 11.0};server=",  :
  [RODBC] ERROR: state IM002, code 0, message [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2: In odbcDriverConnect(paste("driver={SQL Server Native Client 11.0};server=",  :
  ODBC connection failed

mssqlR documentation built on May 2, 2019, 10:16 a.m.