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, UKFax: +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
