prepareConnection {datrProfile}

Prepares connection to RDBS via ODBC

Description

prepareConnection list connection details needed to connecto to a RDBS using ODBC

Usage

prepareConnection(db.vendor, odbc.driver = odbc::odbc(),
  db.host = NULL, db.name = NULL, db.encoding = "", dsn = NULL,
  user = NULL, passwd = NULL)

Arguments

db.vendor

Database vendor (teradata, sqlserver)

odbc.driver

ODBC driver used to connect to database

db.host

Database hostname

db.name

Database name

db.encoding

Database encoding

dsn

Data source name

user

Username to connect to database

passwd

Password to connect to database

Examples

conn.info <- prepareConnection(db.vendor = "teradata",
   dsn = "ODBC_MYDB", user = "myuser", passwd = "mypasswd")