get_server_details

corresponds to the server name key in the YAML <code>file</code> and
should be a string.

server

defaults to <code>NULL</code> which means that it will use
<code>$HOME/sql.yaml</code>.

file


The <code>sql.yaml</code> file in a user's <code>HOME</code> directory can store
server details and login credentials (in plaintext). This works around
the instability associated with jTDS's single-sign on functionality.
The YAML file format is documented in this package's <code>README</code> file, while
an example is provided in <code>extdata/sql.yaml</code> (see example). At a
high level, each server should be documented in its own associative array
with each aspect of the server documented in an associative array.


internal

Utilises The jTDS Project's JDBC 3.0 SQL Server
driver to extend the RJDBC classes and DBI methods. It defines a
SQLServerDriver, SQLServerConnection & SQLServerRsult S4 classes as
extensions of the RJDBC equivalent classes with most DBI
methods being thin extensions of the methods defined by RJDBC classes.
However, the dbConnect interface is more convenient, and the data reading
and writing capabilities found in RJDBC's fetch and dbWriteTable methods
have been refined. The package also implements a SQL backend to the dplyr
package.

get_server_details: Get server details from YAML file

Description

Usage

Arguments

Value

See Also

Examples