RStudio Cloud is Missing ODBC driver for SQLite

Trying to demo the "connections" panel. However, the odbc driver for SQLite is MIA. Any chance this could be installed?

# SQLite ODBC Drivers
apt-get install libsqliteodbc

c.f. https://github.com/r-dbi/odbc#common-db-drivers-1

Drivers installed:

# install.packages("odbc")
odbc::odbcListDrivers()
#>                     name   attribute
#> 1        PostgreSQL ANSI Description
#> 2        PostgreSQL ANSI      Driver
#> 3        PostgreSQL ANSI       Setup
#> 4        PostgreSQL ANSI       Debug
#> 5        PostgreSQL ANSI     CommLog
#> 6        PostgreSQL ANSI  UsageCount
#> 7     PostgreSQL Unicode Description
#> 8     PostgreSQL Unicode      Driver
#> 9     PostgreSQL Unicode       Setup
#> 10    PostgreSQL Unicode       Debug
#> 11    PostgreSQL Unicode     CommLog
#> 12    PostgreSQL Unicode  UsageCount
#> 13               FreeTDS Description
#> 14               FreeTDS      Driver
#> 15               FreeTDS       Setup
#> 16               FreeTDS   CPTimeout
#> 17               FreeTDS     CPReuse
#> 18               FreeTDS  UsageCount
#> 19                 MySQL      Driver
#> 20                 MySQL  UsageCount
#> 21 MySQL ODBC 5.3 Driver      Driver
#> 22 MySQL ODBC 5.3 Driver  UsageCount
#> 23        AmazonRedshift      Driver
#> 24                  Hive      Driver
#> 25                Impala      Driver
#> 26                Oracle      Driver
#> 27            PostgreSQL      Driver
#> 28            Salesforce      Driver
#> 29             SQLServer      Driver
#> 30              Teradata      Driver

Sorry I missed this post when it came in. Yes that is something we can look into adding.

This should now be available.

3 Likes

A post was merged into an existing topic: R Studio is Missing ODBC Driver 13 for SQL Server to Connect R to MsSQL