I'm looking for an optimal approach to access Oracle databases via RWeb applications. I'm new to R but familiar with programming functions and web pages for the S+ Statserver. I'm now going through the motions of migrating S+/Statserver applications to R/RWeb as a feasability exercise. I can access databases using ODBC directly in R or S, and using Statserver, but I have not succeeded at extracting into R in RWebs batch mode. I can 'require RODBC' in .Rprofile with apparent success, but the results of odbcConnect differ from those when the command is typed into the R commands window. Instead of a parameter list I get a -1. Does anyone know the solution to this problem? Also, might anyone know the comparative merits of using some PERL module (like DBD::Oracle) to do the extraction, as opposed to using RODBC (assuming RODBC can be implemented in batch mode)? I'm currently using Apache on Windows XP if relevant, but LINUX may be the final host (we'll compare, but those more Web-wise than I expect LINUX to outperform Windows for our purposes).> Mark Fowler > Marine Fish Division > Bedford Inst of Oceanography > Dept Fisheries & Oceans > Dartmouth NS Canada > fowlerm at mar.dfo-mpo.gc.ca > >
Sounds like a permissions/ownership problem. odbcConnect returnign -1 just means that the ODBC device manager failed. On Tue, 15 Jun 2004, Fowler, Mark wrote:> I'm looking for an optimal approach to access Oracle databases via RWeb > applications. I'm new to R but familiar with programming functions and web > pages for the S+ Statserver. I'm now going through the motions of migrating > S+/Statserver applications to R/RWeb as a feasability exercise. I can access > databases using ODBC directly in R or S, and using Statserver, but I have > not succeeded at extracting into R in RWebs batch mode. I can 'require > RODBC' in .Rprofile with apparent success, but the results of odbcConnect > differ from those when the command is typed into the R commands window. > Instead of a parameter list I get a -1. Does anyone know the solution to > this problem? Also, might anyone know the comparative merits of using some > PERL module (like DBD::Oracle) to do the extraction, as opposed to using > RODBC (assuming RODBC can be implemented in batch mode)? I'm currently using > Apache on Windows XP if relevant, but LINUX may be the final host (we'll > compare, but those more Web-wise than I expect LINUX to outperform Windows > for our purposes). > > > Mark Fowler > > Marine Fish Division > > Bedford Inst of Oceanography > > Dept Fisheries & Oceans > > Dartmouth NS Canada > > fowlerm at mar.dfo-mpo.gc.ca > > > > > > ______________________________________________ > R-help at stat.math.ethz.ch mailing list > https://www.stat.math.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html > >-- 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 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595
Yes, however the same odbcConnect syntax works in the R Commands window. But seemingly not from within a function in .Rprofile when using RWeb to run the function in batch mode. Should mention I have no problem running the function if I bring the data in from the PERL script that runs R. E.g. (whatever edited) Batch (passing function call via an RWeb PERL script) library(RODBC) channel<-odbcConnect('xyz',uid='whatever',pw='whatever',dsn='whatever',case'nochange') cat("\n",channel) -1 Interactive> library(RODBC) >channel<-odbcConnect('xyz',uid='whatever',pw='whatever',dsn='whatever',case'nochange') Warning message: NAs introduced by coercion> channelRODB Connection 0 Details: case=nochange DSN=whatever UID=whatever PWD=whatever DBQ=whatever DBA=W APA=T FEN=T QTO=T FRC=10 FDL=10 LOB=T RST=T FRL=F MTS=F CSR=F PFC=10 TLO=0> Mark Fowler > Marine Fish Division > Bedford Inst of Oceanography > Dept Fisheries & Oceans > Dartmouth NS Canada > fowlerm at mar.dfo-mpo.gc.ca >-----Original Message----- From: Prof Brian Ripley [mailto:ripley at stats.ox.ac.uk] Sent: June 15, 2004 4:04 PM To: Fowler, Mark Cc: 'r-help at stat.math.ethz.ch' Subject: Re: [R] S/R/RWeb/ODBC Sounds like a permissions/ownership problem. odbcConnect returnign -1 just means that the ODBC device manager failed. On Tue, 15 Jun 2004, Fowler, Mark wrote:> I'm looking for an optimal approach to access Oracle databases via > RWeb applications. I'm new to R but familiar with programming > functions and web pages for the S+ Statserver. I'm now going through > the motions of migrating > S+/Statserver applications to R/RWeb as a feasability exercise. I can > S+access > databases using ODBC directly in R or S, and using Statserver, but I > have not succeeded at extracting into R in RWebs batch mode. I can > 'require RODBC' in .Rprofile with apparent success, but the results of > odbcConnect differ from those when the command is typed into the R > commands window. Instead of a parameter list I get a -1. Does anyone > know the solution to this problem? Also, might anyone know the > comparative merits of using some PERL module (like DBD::Oracle) to do > the extraction, as opposed to using RODBC (assuming RODBC can be > implemented in batch mode)? I'm currently using Apache on Windows XP > if relevant, but LINUX may be the final host (we'll compare, but those > more Web-wise than I expect LINUX to outperform Windows for our > purposes). > > > Mark Fowler > > Marine Fish Division > > Bedford Inst of Oceanography > > Dept Fisheries & Oceans > > Dartmouth NS Canada > > fowlerm at mar.dfo-mpo.gc.ca > > > > > > ______________________________________________ > R-help at stat.math.ethz.ch mailing list > https://www.stat.math.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide! > http://www.R-project.org/posting-guide.html > >-- 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 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595