Hello,
I installed the Oracle 11g client on my machine, and tested the
connection to my target Oracle database through MS Access. All seems to
be working fine.
When I try to connect to the very same DB using R with:
channel <- odbcConnect(dsn="MyDSN", uid="XXXXX", pwd="XXXXXXXX",
believeNRows=FALSE)
I get the following error:
In odbcDriverConnect("DSN=MyDSN;UID=XXXX;PWD=XXX", :
[RODBC] ERROR: state HY000, code 12560, message
[Oracle][ODBC][Ora]ORA-12560: TNS:protocol adapter error
Am I missing the installation of some component/driver? I read something
about installing the Oracle Instant Client (free) but thought the Oracle
11g client would be sufficient. What am I missing?
Dan
[[alternative HTML version deleted]]
_______________________________________________
R-sig-DB mailing list -- R Special Interest Group
[email protected]
https://stat.ethz.ch/mailman/listinfo/r-sig-db
