dbConnect-DatabaseConnectorDriver-method function

Create a connection to a DBMS

Create a connection to a DBMS

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

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

Arguments

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

Returns

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

Examples

## Not run: conn <- dbConnect(DatabaseConnectorDriver(), dbms = "postgresql", server = "localhost/ohdsi", user = "joe", password = "secret" ) querySql(conn, "SELECT * FROM cdm_synpuf.person;") dbDisconnect(conn) ## End(Not run)