Create a connection to a DBMS — dbConnect,DatabaseConnectorDriver-method • DatabaseConnector

Connect to a database. This function is synonymous with the connect() function. except a dummy driver needs to be specified

# S4 method for DatabaseConnectorDriver
dbConnect(drv, ...)

Arguments

drv: The result of the DatabaseConnectorDriver() function
...: Other parameters. These are the same as expected by the connect() function.

Value

Returns a DatabaseConnectorConnection object that can be used with most of the other functions in this package.

Examples

if (FALSE) {
conn <- dbConnect(DatabaseConnectorDriver(),
  dbms = "postgresql",
  server = "localhost/ohdsi",
  user = "joe",
  password = "secret"
)
querySql(conn, "SELECT * FROM cdm_synpuf.person;")
dbDisconnect(conn)
}