Oracle ODBC Connection now always requires host, port and SVC

November 12, 2019 @alan_y

@alan_y wrote:

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?

Posts: 4

Participants: 2

Read full topic

Previous Article
Unable to install hexbin in RStudio
Unable to install hexbin in RStudio

@Jason.C wrote: Greetings, I recently updated R and RStudio. Consequently, I hav...

Next Article
RStudio Package Manager 1.1.0 is out now
RStudio Package Manager 1.1.0 is out now

@slopp wrote: Package Manager 1.1.0 - No Interruptions by Sean Lopp, 2019-11-07 ...