mssql_connection: Connect to a Microsoft SQL Server
In omega1x/sqshr: R interface to SQL Server on top of Sqsh

Description Usage Arguments Details Value See Also Examples

View source: R/connection.R

Connections to Microsoft SQL server are executed on top of FreeTDS driver using sqsh command line interface internally. Connections to Microsoft SQL server are made each time the user sends the SQL-request. The object created by the function holds requisites only. So you do not need to disconnect.

Note that sqsh client must be installed on the client's system.

1 2	mssql_connection(server = "", domain = "", user = "", password = "", tds_version = "8.0")

`server`	client hostname or IP-address. The value is associated with -H option of sqsh command.
`domain`	user domain name (if any)
`user`	database username to connect to server. The value is associated with -U option of sqsh command.
`password`	password for username required to connect to server. The value is associated with -P option of sqsh command.
`tds_version`	Set the TDS version to use. Valid versions are 4.0, 4.2, 4.6, 4.9.5, 5.0, 7.0 and 8.0. The value is associated with -G option of sqsh command.

Do not use domain name in user, put it to domain.

Connection object holding requisites of connection

mssql for sending SQL-requests

Other Database: mssql

## Not run: 
# Create connection object:
conn <- mssql_connection(server = "10.100.104.142", domain = "SUEK",
 user = "user", password = "password")

# Ask for data:
 mssql(conn, "SELECT 200 AS V1, 300 AS V2")

# Output:
 #     V1  V2
 # 1: 200 300

## End(Not run)