prepareConnection {datrProfile} | R Documentation |
prepareConnection
list connection details needed to connecto
to a RDBS using ODBC
prepareConnection(db.vendor, odbc.driver = odbc::odbc(),
db.host = NULL, db.name = NULL, db.encoding = "", dsn = NULL,
user = NULL, passwd = NULL)
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 |
conn.info <- prepareConnection(db.vendor = "teradata",
dsn = "ODBC_MYDB", user = "myuser", passwd = "mypasswd")