Connections pane: library(DBI) turned into library(odbc)

[javierluraschi]

copy-paste from rstudio/rstudio#1783
CC: @jmcphers

When I create a new connection to a PostgreSQL DB via odbc:

1. I open the New Connection window
2. I click on PostgreSQL Unicode(x64)
3. I fill in the parameters and click Test (success). The following code is displayed in the lower field:

library(DBI)
con <- dbConnect(odbc::odbc(), .connection_string = "Driver={PostgreSQL Unicode(x64)};database=xxx;
server=xxx;
uid=xxx;
pwd=xxx;
port=5432;")

4. I disconnect con. The following code is displayed in the Connections pane:

library(odbc)
con <- dbConnect(odbc::odbc(), .connection_string = "Driver={PostgreSQL Unicode(x64)};database=xxx;\nserver=xxx;\nuid=xxx;\npwd=xxx;\nport=5432;")

Is there a reason why library(DBI) has turned into library(odbc)?

RStudio 1.1.383

[javierluraschi]

BTW. I don't believe there is a bad side effect here, appart from a slight annoyance.

See

odbc/R/Driver.R

Line 124 in 5a31675

c("library(odbc)", deparse(expr)), collapse = "\n"))

[jimhester]

hmm, we should change this for sure though, ideally we should not be promoting attaching odbc

[javierluraschi]

Fair enough, here is a PR: #195