get_mssql_driver: retrieves default driver

In BCHSI/credbl: Credbl: Database Credential Management

retrieves default driver

Description

retrieves default driver (Mac / Unix: FreeTDS, Windows: SQL Server)

Usage

get_mssql_driver(dbconfig = list())

Arguments

dbconfig

configuration list (optional)

Value

dbconfig configuration list with driver name appended: list(driver="drivername", ...)

Examples

dbconfig <- read_yaml("database_info.yaml")
dbconfig <- get_mssql_driver(dbconfig)
credentials <- get_credentials(dbconfig$server)

connection <- DBI::dbConnect(
    odbc(),
    driver=dbconfig$driver,
    server=dbconfig$server,
    port=dbconfig$port,
    uid=credentials$uid,
    pwd=credentials$pwd,
    database='mydatabase'
    )

BCHSI/credbl documentation built on April 16, 2023, 4:17 a.m.