[R] RODBC Bug?

Prof Brian Ripley ripley at stats.ox.ac.uk
Tue Jan 9 13:52:06 CET 2001


> Date: Tue, 9 Jan 2001 04:43:19 -0800 (PST)
> From: Samir Mishra <sqmishra at excite.com>
> 
> I'm not sure if this problem is repeatable or particular to my machine. 
> 
> The following works fine -
> > odbcConnect("demoteam", uid = "demo", pwd = "demo")
> 
> This causes R to crash -
> > oracle.info <- list(channel = "demoteam", uid = "demo", pwd = "demo")
> > demo.db.connect <- function(ora.info = oracle.info) {
> + 	channel <- odbcConnect(ora.info$channel, uid = ora.info$uid, 
> + 	pwd = ora.info$pwd)
> + 	if(channel == -1) stop("Connection Failure")
> + 	channel
> +}
> > #R shuts down as soon as I submit the next command
> > channel <- demo.db.connect()

It's very unlikely that we can debug this for you, especially as you
haven't told us what version you are using of anything.  In particular,
the problem may well be in your ODBC client library and not in R.

RODBC works well for me on both Windows and Linux, but I don't use
Oracle.

-- 
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 272860 (secr)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._



More information about the R-help mailing list