Re: [R] R connectivity with Oracle DB

2009-05-29 Thread Franzini, Gabriele [Nervianoms]
Hello Madan, I am rather novice as well, so I went the ODBC way. If you define an ODBC connection to Oracle, with System DSN dsn-name, the code to get the results of a query into, say, mydata is like : library(RODBC) # First of all channel <- odbcConnect("dsn-name", uid="someuser") # double quot

Re: [R] R connectivity with Oracle DB

2009-05-28 Thread Duncan Murdoch
On 28/05/2009 6:03 AM, Madan Mohan wrote: Hi Friends, I am working on R-2.9.0 and i want to connect oracle through R, but i could not find ROracle (zip file for windows) on CRAN Packages. Can anyone suggest me how to connect Oracle from R in windows platform? I would be grateful if u can provide

Re: [R] R connectivity with Oracle DB

2009-05-28 Thread Prof Brian Ripley
See http://cran.r-project.org/bin/windows/contrib/2.9/@ReadMe (ReadMe files are there to be read!) and consider the use of RODBC, which is used by lots of Oracle users as an R client on Windows. On Thu, 28 May 2009, Madan Mohan wrote: Hi Friends, I am working on R-2.9.0 and i want to connec

[R] R connectivity with Oracle DB

2009-05-28 Thread Madan Mohan
Hi Friends, I am working on R-2.9.0 and i want to connect oracle through R, but i could not find ROracle (zip file for windows) on CRAN Packages. Can anyone suggest me how to connect Oracle from R in windows platform? I would be grateful if u can provide me code aswell. Thanks & Regards, Madan -