Web: https://www.reddit.com/r/datascience/comments/sh95c9/connecting_r_to_oracle_database/

Jan. 31, 2022, 7:03 p.m. | /u/Ambiguous_Colors

Data Science reddit.com

I am on R 4.1.2 and have been looking everywhere to try and solve why I am getting a “Java.sql.SQLRecoverableException: The network Adaptor could not establish the connection ()” error when I run dbConnect. The following code i am using is below:

jdbcDriver <- JDBC(driverClass = “oracle.jdbc.OracleDriver”, classPath = (/users/desktop/folder/ojdbc11.jar”) ##okay

jdbcConnect <- dbConnect(jdbcDriver, “jdbc:oracle:thin:@//host:port/databasename”, “scheme”, “password”)

My user name and scheme are the same. Other blogs or post on stackoverflow are connecting usually to my SQL and the one …

database datascience oracle

Data Analytics and Technical support Lead

@ Coupa Software, Inc. | Bogota, Colombia

Data Science Manager

@ Vectra | San Jose, CA

Data Analyst Sr

@ Capco | Brazil - Sao Paulo

Data Scientist (NLP)

@ Builder.ai | London, England, United Kingdom - Remote

Senior Data Analyst

@ BuildZoom | Scottsdale, AZ/ San Francisco, CA/ Remote

Senior Research Scientist, Speech Recognition

@ SoundHound Inc. | Toronto, Canada