On 64-bit win7:

I have a DSN which tests successfully in control panel. I can connect from RGui 

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.


        [[alternative HTML version deleted]]

ESS-help@r-project.org mailing list

Reply via email to