![](../logo.png)
Create a named list of connection arguments to translate to bcp and sqlcmd options
Source:R/bcp.R
makeConnectArgs.Rd
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.