I have been trying to create a database and installed the "DBI" package, but I am still facing this error. I reinstalled DBI and RSQLite package, but they don’t seem to work.
library("DBI")
con <- dbConnect
(RSQLite::SQLite(), dbname = ":memory:")
dbListTables(con)
Error:
Error in connection_connect(dbname, loadable.extensions, flags, vfs, extended_types) : function 'Rcpp_precious_remove' not provided by package 'Rcpp'
I had the same problem with another package and the issue was that I was running a recent version of the package compiled against a previous version of Rcpp
. As user20650 points out in the comment, updating Rcpp
to 1.0.7 should fix it:
install.packages('Rcpp')
In RStudio you can also use the packages
panel to update the packages, as in the following image: