[R] S/R/RWeb/ODBC

[Fowler, Mark]

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 

> channel
RODB 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