I doubt it's problem with ESS. Running R from emacs shell and with ESS should be
equivalent. Make sure that it's indeed the same R instance and RODBC what are
called in your experiments. Do you have a custom inferior-ess-r-program-name
Do you issue Rterm or R in the emacs shell?
>> On Wed, Dec 13 2017 22:23, Bond, Stephen wrote:
> 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.
> From: Bond, Stephen
> Sent: Wednesday, December 13, 2017 12:53 PM
> To: 'firstname.lastname@example.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:
> 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',
> 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
> 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.
> [[alternative HTML version deleted]]
> ESSemail@example.com mailing list
ESSfirstname.lastname@example.org mailing list