odbcDataSources {RODBC}R Documentation

List ODBC Data Sources

Description

List known ODBC data sources.

Usage

odbcDataSources(type = c("all", "user", "system"))

Arguments

type User DSNs, system DSNs or all?

Value

A named character vector of DSN descriptions, with names the DSNs.

Examples

## Not run: 
odbcDataSources()
        test      sqlite3       testpg 
#    "MySQL"    "sqlite3" "PostgreSQL"
or
                          testdb3                            mysql5
         "MySQL ODBC 3.51 Driver"         "MySQL Connector/ODBC v5"
                          sqlite3                           bdr.xls
            "SQLite3 ODBC Driver"  "Microsoft Excel Driver (*.xls)"
                          testacc                            testpg
"Microsoft Access Driver (*.mdb)"                 "PostgreSQL ANSI"
                          testdb5                         SQLServer
          "MySQL ODBC 5.1 Driver"               "SQL Native Client"
                SQLite Datasource           SQLite UTF-8 Datasource
             "SQLite ODBC Driver"      "SQLite ODBC (UTF-8) Driver"
               SQLite3 Datasource
            "SQLite3 ODBC Driver"
## End(Not run)

[Package RODBC version 1.2-6 Index]