I have been having some trouble getting my connection set up to an Oracle database in R. I recently changed my machine (Dell running Windows) to a MacBook Pro (macOS High Sierra version 10.13.5). After a lot of work with my DBA, was finally able to connect to the database using R (both in the terminal and in R), but when I run the same code to connect in RStudio, I get a fatal error and RStudio crashes. The code I am running is:
library(RODBC) con <- odbcConnect("dsn", uid = "username", pwd = "password")
I already tried uninstalling and reinstalling RStudio, but the issue is still happening.
I have no clue why this won't work in RStudio. Any help is greatly appreciated.
NOTE: I get the same issue when I use the odbc package instead of RODBC.