I have a problem with db-connections and my connections pane in R-studio.
If I create a databaseconnection like
readcon <- DBI::dbConnect(odbc::obdbc(), ...)
The connection will appear in the connections pane.
I can then close the connection with
The connection will then be closed in the connections pane.
However. If I open two connections only one connection appears in the pane.
If I remove the second connection the connection pane will show that there are no open connections.
readcon <- DBI::dbConnect(odbc::obdbc(), ...) readcon_2 <- DBI::dbConnect(odbc::obdbc(), ...) DBI::dbDisconnect(readcon_2)
However, the first connection
readconis still alive and I can call it:
I can still close the connection but if I remove the refererence the connection will be loose.
Only restarting the session will remove the connection.
- Is this a Bug in the connections pane?
- Can I see open connections without reference?
This looks like a bug to me