An Oracle database connection used to work (on the open source version of RStudio Server) using just the following details:
connection <- odbc::dbConnect(
drv = odbc::odbc(),
dsn = "dsn_name",
uid = "my_uid",
pwd = "my_pwd")
Notice that it never needs specific details like host, port and SVC.
But now when I try on RStudio Server Pro, it seems to make it essential to also enter details on host, port number and SVC every time.
Error: nanodbc/nanodbc.cpp:950: 08001: [unixODBC][RStudio][ODBC] (10380) Unable to establish a connection with data source. Missing settings: {[HOST] [PORT] [SVC]}
My feeling is that this may be an issue with how the Oracle drivers have been set up on RStudio Server Pro - would anybody be able to offer some advice please?