Hi,
I seem to have some kind of environment problem with my REnterprise installation, but I can't quite figure out what it is. I get the error
"ORA-12557: TNS:protocol adapter not loadable" in the following two contexts:
i) On the server (background) when connected to the database from an R client and trying to run a script with ore.doEval, or
ii) in certain situations in R when trying to connect to the database.
Let me explain (ii). I am using the R installation on the database server (windows machine), and the connection to the database works a) in RGui, b) in Rterm.exe, but NOT in R.exe.
Now if the database server calls R.exe to executes scripts this will also explain i.
What is the difference between Rterm.exe and R.exe that makes one work and the other fail?
Thanks in advance for any help!