sqrlSources: List Data Sources and their Interfaces

Description Usage Arguments Value Note See Also Examples

View source: R/SQRL.R

Description

Returns a summary of defined data sources. These will consist of system and user DSNs, plus any additional sources defined via sqrlSource.

Usage

1

Arguments

...

An optional character string. If set to one of “all”, “user”, or “system”, then a call is made to RODBC:odbcDataSources (with the corresponding type value) to re-examine that class of data source names (DSNs) and import all those found. If set to “remove”, then all currently defined sources are deregistered.

Value

Returns a data frame of data source details.

Note

The return frame may have zero rows, if no data sources are defined.

Sources need only to have been defined; they need not actually exist.

DSNs with “Access”, “dBASE”, or “Excel” in their names are not automatically imported. They can be manually added via sqrlSource.

See Also

sqrlInterface, sqrlSource, RODBC:odbcDataSources

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
# Review defined sources.
sqrlSources()

## Not run: 
# Sample sqrlSources() output:

   name interface open    uid                     driver
1 chaos     chaos    N zarkov       PostgreSQL ANSI(x64)
2 order      <NA>    N zarkov MySQL ODBC 5.3 ANSI Driver

# Here, there are two data sources; 'order' and 'chaos'.
# The interface to 'chaos' is a function of the same name.
# No interface has yet been defined for 'order' (use of
# that name is prevented due to its conflicting with the 
# base:order function). Neither source (channel) is open.

# Contents of the 'uid' column can be incorrect when the
# UID is contained within a DSN. As such, this column is
# likely to be absent in the next release.

## End(Not run)

# Remove all sources.
sqrlSources("remove")

# Reload user DSNs.
sqrlSources("user")

SQRL documentation built on June 4, 2018, 1:03 a.m.