I am signed up and able to access WRDS, but struggling to access the datasets through Posit. After successfully connecting to the database, I am not able to run the following code:
schemas <- DBI::dbGetQuery(wrds, "SELECT schema_name FROM information_schema.schemata")
Error in (function (classes, fdef, mtable) :
unable to find an inherited method for function ‘dbGetQuery’ for signature ‘"standardGeneric", "character"’
Also, I've tried the following code without success either:
msf_db <- tbl(wrds, in_schema("crsp", "msf"))
Error in UseMethod("tbl") :
no applicable method for 'tbl' applied to an object of class "c('standardGeneric', 'genericFunction', 'function', 'OptionalFunction', 'PossibleMethod', 'optionalMethod')"
Do I need to log into WRDS via an RStudio account vs Posit?
Any assistance would be greatly appreciated.
Dean