Re: [ESS] connection to Oracle does not work in ESS
ESS or emacs stores sth between sessions! I tried quitting the R session and connecting from a new session in the same emacs window and it did not work. Today I closed the whole emacs window and reopened the same R code and it worked. Stephen -Original Message- From: Vitalie Spinu [mailto:spinu...@gmail.com] Sent: Wednesday, December 13, 2017 5:34 PM To: Bond, Stephen Cc: 'ess-help@r-project.org' Subject: Re: [ESS] connection to Oracle does not work in ESS Hi Stephen, 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 setup? Do you issue Rterm or R in the emacs shell? Vitalie >> 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. > Stephen > From: Bond, Stephen > Sent: Wednesday, December 13, 2017 12:53 PM > To: 'ess-help@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]] > __ > ESS-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/ess-help __ ESS-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/ess-help
Re: [ESS] connection to Oracle does not work in ESS
Hi Stephen, 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 setup? Do you issue Rterm or R in the emacs shell? Vitalie >> 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. > Stephen > From: Bond, Stephen > Sent: Wednesday, December 13, 2017 12:53 PM > To: 'ess-help@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]] > __ > ESS-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/ess-help __ ESS-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/ess-help
[ESS] 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]] __ ESS-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/ess-help