Thank you for taking the time to read my issue. I am connecting to an Oracle database with the supported Oracle driver from the supported RStudio drivers. The following code:
con <- DBI::dbConnect( odbc::odbc() , Driver = "RStudio-Oracle" , TNS = "<xxx>" , UID = "<username>" , PWD = rstudioapi::askForPassword("Enter Password") )
runs when I manually highlight the code and run as a segment. However, when I attempt run as a "sourced" script it reacts as expected by popping up the external password box and waits for the user to enter their password. The problem is that the script continues without error, but no connection is made. I have to go back and manually run the code segment by hand.
Any suggestions are appreciated.