[R] ODBC Oracle access
M.Mamin at intershop.de
Tue Aug 26 10:02:08 CEST 2003
Did you check the ODBC connection independently from R?
there is an Oracle tool for this (under Menu Network Administration).
I'm doing fine with a simpler call to odbcConnect:
further parameters may not be necessary if you pay attention to only use
uppercase names, and I guess that "believeNRows" is superfluous with the
latest Oracle ODBC Client(s) if it is well configured.
From: Toby.Patterson at csiro.au [mailto:Toby.Patterson at csiro.au]
Sent: Tuesday, August 26, 2003 1:57 AM
To: r-help at stat.math.ethz.ch
Subject: [R] ODBC Oracle access
I'm having trouble connecting to an oracle database using RODBC under
winXP. Unfortunately I can't really send a reproducable error as the
initial call to odbcConnect seems to hangs R and I have to kill the
I have been using RODBC to sucessfully connect to an MS Access DB that
has tables linked through to the oracle database in question and that
seems to work OK but it would be preferable to cut out the MS access
The command I'm attempting to use is:
conn<- odbcConnect(dsn='myDSN', uid = "myUID", pwd = "myPWD", case =
I wouldn't be surprised if there is an issue with the dsn configuration
and not R (though I cant find it) so any tips as to things that I should
check there would also be gratefully received.
system i386, mingw32
Pelagic Fisheries and Ecosystems
CSIRO Marine Research
R-help at stat.math.ethz.ch mailing list
More information about the R-help