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 > [EMAIL PROTECTED] > -----Original Message----- From: Prof Brian Ripley [mailto:[EMAIL PROTECTED] Sent: June 15, 2004 4:04 PM To: Fowler, Mark Cc: '[EMAIL PROTECTED]' 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 > > [EMAIL PROTECTED] > > > > > > ______________________________________________ > [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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 ______________________________________________ [EMAIL PROTECTED] 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