[ESS] connection to Oracle does not work in ESS
Bond, Stephen
Stephen@Bond @end|ng |rom c|bc@com
Wed Dec 13 23:23:51 CET 2017
Further info:
When I use Rterm in a cmd shell the connection works.
When I use Rterm in a shell within Emacs the connection works.
Something must be going wrong in the way ESS does things.
Stephen
From: Bond, Stephen
Sent: Wednesday, December 13, 2017 12:53 PM
To: 'ess-help using r-project.org'
Subject: connection to Oracle does not work in ESS
On 64-bit win7:
I have a DSN which tests successfully in control panel. I can connect from RGui with:
con=odbcConnect("DSNname",uid="myuid",pwd="mypass")
it does not work in ESS:
R version 3.4.2 (2017-09-28) -- "Short Summer"
Copyright (C) 2017 The R Foundation for Statistical Computing
Platform: x86_64-w64-mingw32/x64 (64-bit)
> > options(chmhelp=FALSE, help_type="text")
> options(STERM='iESS', str.dendrogram.last="'", editor='emacsclient.exe', show.error.locations=TRUE)
> library(RODBC)
> con=odbcConnect("DSNname",uid="myuid",pwd="mypass")
Warning messages:
1: In RODBC::odbcDriverConnect() :
[RODBC] ERROR: state 08004, code 12154, message [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified
2: In RODBC::odbcDriverConnect() :
ODBC connection failed
I have all the paths setup and the driver is installed correctly. Tnsping finds the db.
Let me know if anybody can help.
Stephen
[[alternative HTML version deleted]]
More information about the ESS-help
mailing list