Connect/disconnect to a ODBC data source

Description

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

Usage

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

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.

...

Other parameters passed on to methods

Examples

1
2
3
4
5
6
7
## Not run: 
# Connect to a ODBC data source
con <- dbConnect(RODBCDBI::ODBC(), dsn="test")
# Always cleanup by disconnecting the database
#' dbDisconnect(con)

## End(Not run)