[R] RODBC Bug?

[Samir Mishra]

My last message did not provide all the relevant information, sorry about
the oversight. I'll start again...

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 also works as expected -
> demo.db.connect <- function(channel = "demoteam", uid = "demo", 
+ pwd = "demo") {
+ 	channel <- odbcConnect(channel = channel, uid = uid, pwd = pwd)
+ 	if(channel == -1) stop("Connection Failure")
+	channel
+}
> channel <- demo.db.connect()


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()



Version Info - 
> version
         _              
platform i386-pc-mingw32
arch     x86            
os       Win32          
system   x86, Win32     
status                  
major    1              
minor    2.0            
year     2000           
month    12             
day      15             
language R              

Platform - WinNT
ODBC Driver  - Oracle ODBC Driver Ver. 8.01.05.00 (02/02/99)

I've worked around the problem so this is not an issue, but I was curious to
know if anyione else had experienced similar problems. Also, I was curious
to know if there were any other issues I ought to be aware of, just so I can
save some time later.

Thanks.

SM





Samir Mishra
===========================================
Please send replies to :
sqmishra at acm.org
===========================================





_______________________________________________________
Send a cool gift with your E-Card
http://www.bluemountain.com/giftcenter/


-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._