CODEWITHSUNDEEP
databaseroracle-databaserstudio
maniA
maniA

Reputation: 1457

R and database Roracle

I am using Rstudio (or R) with the package ROracle to connect to db. However I have the following error message

Error in .oci.Connect(.oci.drv(), username = username, password = password,  : 
ORA-12154: TNS:could not resolve the connect identifier specified

One possible solution is to add the following line to the .Renviron file. But I guess my R does not read this file. How can I be sure, or force R to read .Renviron? (I am using Windows.)

Some other suggestion from Oracle are here.

I am so grateful for every hint.

Upvotes: 1

Views: 700

Answers (1)

shadow
shadow

Reputation: 22293

You can read the .Renviron file with the readRenviron function. Just make sure you enter the correct file path. 

readRenviron(".Renviron")

Upvotes: 1

Related Questions