makeConnectArgs {bcputility} | R Documentation |
Create a named list of connection arguments to translate to bcp and sqlcmd options
Description
Create a named list of connection arguments to translate to bcp and sqlcmd options
Usage
makeConnectArgs(
server,
database,
username,
password,
trustedconnection = TRUE,
trustservercert = FALSE,
azure = FALSE,
quotedidentifiers = FALSE
)
Arguments
server |
the instance of SQL Server to which to connect |
database |
specifies the database to connect to |
username |
login ID |
password |
password for login ID |
trustedconnection |
use integrated security, username and password are not required |
trustservercert |
trust the server certificate |
azure |
use Azure Active Directory authentication, does not work with integrated authentication. |
quotedidentifiers |
set QUOTED_IDENTIFIERS option to 'ON' for the connection between bcp/sqlcmd and SQL Server. |
Value
a list with connection arguments
[Package bcputility version 0.4.3 Index]