Returns a summary of defined data sources.
These will consist of system and user DSNs, plus any additional
sources defined via
An optional character string.
If set to one of “all”, “user”, or “system”, then a call is
Returns a data frame of data source details.
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
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")
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.