[R] S/R/RWeb/ODBC

[Prof Brian Ripley]

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