Re: [R] Error while connecting to Oracle using RODBC package

2010-07-15 Thread vikrant
Thanks Marc & Daniel for your replies. I am now able to connect R to oracle using RODBS. There was an error while setting up the DSN. Now it is solved. Thanks once again -- View this message in context: http://r.789695.n4.nabble.com/Error-while-connecting-to-Oracle-using-RODBC-package-tp22883

Re: [R] Error while connecting to Oracle using RODBC package

2010-07-14 Thread Daniel Nordlund
> -Original Message- > From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org] > On Behalf Of Marc Schwartz > Sent: Wednesday, July 14, 2010 7:05 AM > To: vikrant > Cc: r-help@r-project.org > Subject: Re: [R] Error while connecting to Oracle using RODB

Re: [R] Error while connecting to Oracle using RODBC package

2010-07-14 Thread Marc Schwartz
On Jul 13, 2010, at 11:57 PM, vikrant wrote: > > Dear All, > I want to connnect R with oracle. I am using RODBC package for this > connection. Following is my code to connect > > library(RODBC) > channel <- odbcConnect("Vikrant") > > I am getting following error. > 1: In odbcDriverConnect("DSN

Re: [R] Error while connecting to Oracle using RODBC package

2010-07-14 Thread vikrant
Please help if anybody has got this error earlier. Or please explain how should I use package RODBC to connect to oracle -- View this message in context: http://r.789695.n4.nabble.com/Error-while-connecting-to-Oracle-using-RODBC-package-tp2288304p2288389.html Sent from the R help mailing list ar

[R] Error while connecting to Oracle using RODBC package

2010-07-13 Thread vikrant
Dear All, I want to connnect R with oracle. I am using RODBC package for this connection. Following is my code to connect library(RODBC) channel <- odbcConnect("Vikrant") I am getting following error. 1: In odbcDriverConnect("DSN=Vikrant") : [RODBC] ERROR: state NA000, code 12288, message [M