I recently updated R Studio and odbc/dbi seems to be broken. I’m using:

#Connect to data on SQL developer (oracle)
cj_db <- dbConnect(odbc::odbc(), "my_database", UID='my_name', PWD = 'my_password')

Which has always worked in the past. Now I get an error:

Error in UseMethod("odbcListObjects") : 
  no applicable method for 'odbcListObjects' applied to an object of class "Oracle"

I’ve tried the solution listed here:

rstudio dbi odbc connect Driver for SQL Server

devtools::install_github("r-dbi/odbc")

I get a warning: Warning: package ‘odbc’ is in use and will not be installed

And it doesn’t work. I still get the same error. And I’ve tried re-starting. No luck. I wish updating R Studio didn’t break all my scripts, but here we are.