R to Oracle via RODBC
RODBC has not been updated for R 1.5.x (and hence is in the Devel area on CRAN. One issue is the change in NA handling in R, but I think this is incorrect usage.
On Fri, 2 Aug 2002, Vikram Khurana wrote:
Howdy, I'm trying to use R to access Oracle 8i using the RODBC package On Linux Red Hat 7.3. Specs R version 1.51 Driver: Easysoft ODBC - Oracle driver Driver Manager: unixODBC I get the following error when trying to executing RODBC commands. Can anybody give me pointers as to what I'm missing or doing wrong
> library(RODBC)
> channel <- ("DSNName")
That's not right. It should be a call to odbcConnect.
> sqlQuery(channel,"select * from tableX")
Error in odbcQuery(channel, query) : NAs in foreign function call (arg 1) In addition: Warning message: NAs introduced by coercion
> odbcTables(channel)
Error in odbcTables(channel) : NAs in foreign function call (arg 1) In addition: Warning message: NAs introduced by coercion I am successfully able to run queries on the Oracle 8i database using Oracle SqlPlus and also using Easysoft's isql(which uses the odbc.ini file) The .odbc.ini file in the root folder looks as follows: [DSNName] Driver = ORACLE Database = ServerName User = userName Password = pwd METADATA_ID = 0 ENABLE_USER_CATALOG = 1 ENABLE_SYNONYMS = 1
(Is that really correct? You are supposed to fill in entries 2 to 4. Does this work from a simple ODBC client?)
Any help is very appreciated!! Vikram -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
Brian D. Ripley, ripley at stats.ox.ac.uk Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272860 (secr) Oxford OX1 3TG, UK Fax: +44 1865 272595 -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._