epidm (version 1.0.4)

sql_connect: Connect to a SQL database

Description

An function to help setup connections to SQL databases acting as a wrapper for the odbc and DBI packages. Used by other sql_* tools within epidm. This uses the credential manager within the system and assumes you are using a trusted connection.

Usage

sql_connect(server, database)

Value

a SQL connection object

Arguments

server

a string containing the server connection; note that servers may require the use of double backslash \\

database

a string containing the database name within the data store

See Also

sql_clean sql_read sql_write

Examples

if (FALSE) {
sql <- list(
  dsn = list(ser = 'covid.ukhsa.gov.uk',
             dbn = 'infections')
)

sgss_con = sql_connect(server = sql$dsn$ser, database = sql$dsn$dbn)
}