dbConnect-ODBCDriver-method: Connect/disconnect to a ODBC data source

In teramonagi/RODBCDBI: Provides Access to Databases Through the ODBC Interface

Description

These methods are straight-forward implementations of the corresponding generic functions.

Usage

## S4 method for signature 'ODBCDriver'
dbConnect(drv, dsn, user = NULL, password = NULL,
  connection, ...)

Arguments

drv	an object of class ODBCDriver
dsn	Data source name you defined by ODBC data source administrator tool.
user	User name to connect as.
password	Password to be used if the DSN demands password authentication.
connection	Connection string to use to connect to the ODBC database server (as per odbcDriverConnect, e.g. 'driver=SQL Server;server=mysqlhost;database=mydbname;trusted_connection=true')
...	Other parameters passed on to methods

Examples

## Not run: 
# Connect to a ODBC data source
con <- dbConnect(RODBCDBI::ODBC(), dsn="test")
# or using a connection string
con <- dbConnect(RODBCDBI::ODBC(),
  connection="driver={SQL Server};server=mysqlhost;
  database=mydbname;trusted_connection=true")
# Always cleanup by disconnecting the database
#' dbDisconnect(con)

## End(Not run)

teramonagi/RODBCDBI documentation built on May 31, 2019, 8:37 a.m.