sqrlSources

Returns a summary of defined data sources.
These will consist of system and user <acronym>DSN</acronym>s, plus any additional
sources defined via <code>sqrlSource</code>.

interface

database

Provides simple and powerful interfaces that facilitate interaction
with 'ODBC' data sources. Each data source gets its own unique and dedicated
interface, wrapped around 'RODBC'. Communication settings are remembered
between queries, and are managed silently in the background. The interfaces
support multi-statement 'SQL' scripts, which can be parameterised via
metaprogramming structures and embedded 'R' expressions.

Mike Lee

SQRL

Enhances Interaction with 'ODBC' Databases

sqrlSources function

<dl> <dt>...</dt>
<dd>An optional character string.
If set to one of &#8220;all&#8221;, &#8220;user&#8221;, or &#8220;system&#8221;, then a call is
made to <code>RODBC::odbcDataSources</code> (with the
corresponding <var>type</var> value) to re-examine that class of data source names
(<acronym>DSN</acronym>s) and import all those found.
If set to &#8220;remove&#8221;, then all currently defined sources are deregistered.</dd></dl>

Arguments

List Data Sources and their Interfaces — sqrlSources

<dl>

 <dt>...</dt>
<dd>An optional character string.
If set to one of &#8220;all&#8221;, &#8220;user&#8221;, or &#8220;system&#8221;, then a call is
made to <code>RODBC::odbcDataSources</code> (with the
corresponding <var>type</var> value) to re-examine that class of data source names
(<acronym>DSN</acronym>s) and import all those found.
If set to &#8220;remove&#8221;, then all currently defined sources are deregistered.</dd>

</dl>

sqrlSources: List Data Sources and their Interfaces

Description

Usage

Value

Arguments

See Also