zinternal_connect_odbc: Creates an ODBC Connection

In N1h1l1sT/dbautojoinr: Automatic Joining of SQL Tables

Description

Creates an ODBC Connection

Usage

zinternal_connect_odbc(
  Driver,
  Database,
  Server,
  UID,
  PWD,
  Trusted_Connection,
  Port = 1433
)

Arguments

Driver	A string. A SQL Driver for SQL Server, Postgre, etc., e.g.: "SQL Server;"
Database	A string. The name of the SQL Database itself
Server	A string. A name that resolves into the SQL Machine, or the IP to the SQL Machine
UID	A string. The Username credential for the SQL Connection. NULL if Windows Login is to be used
PWD	A string. The Password credential for the SQL Connection. NULL if Windows Login is to be used
Trusted_Connection	A Boolean. TRUE or FALSE on whether Windows Login/Credentials are to be used instead of a UID/PWD, if a string is used it'll be passed as is.
Port	An Integer. The Port which the SQL Listener is listening at. Can be left blank whereupon it will default to 1433

Examples

zinternal_connect_odbc(Driver = "{SQL Server};", Database = "Chronogramme", Server = '123.456.7.8', UID = NULL, PWD = NULL, Trusted_Connection = TRUE, Port = 1433)

N1h1l1sT/dbautojoinr documentation built on Jan. 24, 2021, 10:15 a.m.