Hi I Can't connect to the Oracle database, any tips? Has anybody actually got ROracle up and running on windows? >> unable to find an inherited method for function "dbConnect", for signature "OraDriver" I can happily connect to the same database through RODBC. Oracle client, version 9.2 installed, amongst others. Sean> library(DBI) > library(ROracle) > > packageDescription("ROracle")Package: ROracle Version: 0.5-7 Date: 2006-02-13 Title: Oracle database interface for R Author: David A. James <dj at bell-labs.com> Jake Luciani <jakeluciani at yahoo.com> Maintainer: David A. James <dj at bell-labs.com> Description: Oracle database interface (DBI) driver for R. This is a DBI-compliant Oracle driver based on the ProC/C++ embedded SQL. It implements the DBI version 0.1-8 plus one extension. SaveImage: yes Depends: R (>= 2.0.0), methods, DBI (>= 0.1-8) License: LGPL version 2 or newer URL: http://stat.bell-labs.com/RS-DBI http://www.omegahat.org Packaged: Mon Feb 13 18:05:55 2006; dj Built: R 2.2.1; i386-pc-mingw32; 2006-02-13 18:05:59; windows -- File: C:/PROGRA~1/R/R-26~1.0/library/ROracle/DESCRIPTION> packageDescription("DBI")Package: DBI Version: 0.2-4 Title: R Database Interface Author: R Special Interest Group on Databases (R-SIG-DB) Maintainer: David A. James <daj025 at gmail.com> Depends: R (>= 2.3.0), methods Imports: methods Description: A database interface (DBI) definition for communication between R and relational database management systems. All classes in this package are virtual and need to be extended by the various R/DBMS implementations. LazyLoad: yes License: LGPL (version 2 or later) Collate: DBI.R Util.R zzz.R Packaged: Tue Oct 16 21:43:31 2007; dj Built: R 2.6.0; ; 2007-10-17 12:21:14; windows -- File: C:/PROGRA~1/R/R-26~1.0/library/DBI/DESCRIPTION> > R.Version()$platform [1] "i386-pc-mingw32" $arch [1] "i386" $os [1] "mingw32" $system [1] "i386, mingw32" $status [1] "" $major [1] "2" $minor [1] "6.0" $year [1] "2007" $month [1] "10" $day [1] "03" $`svn rev` [1] "43063" $language [1] "R" $version.string [1] "R version 2.6.0 (2007-10-03)"> > > sDB_un<- "scott" > sDB_pwd<- "tiger" > > > Oracle()An object of class "OraDriver" Slot "Id": [1] 1952> dbDriver("Oracle")An object of class "OraDriver" Slot "Id": [1] 1952> > Ora<- dbDriver("Oracle") > Con <- dbConnect(Ora, user = sDB_un, passwd = sDB_pwd)Error in function (classes, fdef, mtable) : unable to find an inherited method for function "dbConnect", for signature "OraDriver">
Where did you get your ROracle package from?> Built: R 2.2.1; i386-pc-mingw32; 2006-02-13 18:05:59; windowsindicates it was too old. All methods-using packages need to have been installed recently, and definitely since 2.4.0. (It is unsafe to use one that has not been installed for the same 'y' in 2.y.z because of its propensity for extracting bits of the R under which the package was installed.) So 'step 1' is to install ROracle from the sources. On Wed, 23 Apr 2008, Creighton, Sean wrote:> Hi > > I Can't connect to the Oracle database, any tips? Has anybody actually > got ROracle up and running on windows? > > >> unable to find an inherited method for function "dbConnect", > for signature "OraDriver" > > I can happily connect to the same database through RODBC. Oracle client, > version 9.2 installed, amongst others. > > Sean > > > > > >> library(DBI) >> library(ROracle) >> >> packageDescription("ROracle") > Package: ROracle > Version: 0.5-7 > Date: 2006-02-13 > Title: Oracle database interface for R > Author: David A. James <dj at bell-labs.com> Jake Luciani > <jakeluciani at yahoo.com> > Maintainer: David A. James <dj at bell-labs.com> > Description: Oracle database interface (DBI) driver for R. This is a > DBI-compliant Oracle driver based on the ProC/C++ embedded SQL. It > implements the DBI version 0.1-8 plus one extension. > SaveImage: yes > Depends: R (>= 2.0.0), methods, DBI (>= 0.1-8) > License: LGPL version 2 or newer > URL: http://stat.bell-labs.com/RS-DBI http://www.omegahat.org > Packaged: Mon Feb 13 18:05:55 2006; dj > Built: R 2.2.1; i386-pc-mingw32; 2006-02-13 18:05:59; windows > > -- File: C:/PROGRA~1/R/R-26~1.0/library/ROracle/DESCRIPTION >> packageDescription("DBI") > Package: DBI > Version: 0.2-4 > Title: R Database Interface > Author: R Special Interest Group on Databases (R-SIG-DB) > Maintainer: David A. James <daj025 at gmail.com> > Depends: R (>= 2.3.0), methods > Imports: methods > Description: A database interface (DBI) definition for communication > between R and relational database management systems. All classes in > this package are virtual and need to be extended by the various > R/DBMS implementations. > LazyLoad: yes > License: LGPL (version 2 or later) > Collate: DBI.R Util.R zzz.R > Packaged: Tue Oct 16 21:43:31 2007; dj > Built: R 2.6.0; ; 2007-10-17 12:21:14; windows > > -- File: C:/PROGRA~1/R/R-26~1.0/library/DBI/DESCRIPTION >> >> R.Version() > $platform > [1] "i386-pc-mingw32" > > $arch > [1] "i386" > > $os > [1] "mingw32" > > $system > [1] "i386, mingw32" > > $status > [1] "" > > $major > [1] "2" > > $minor > [1] "6.0" > > $year > [1] "2007" > > $month > [1] "10" > > $day > [1] "03" > > $`svn rev` > [1] "43063" > > $language > [1] "R" > > $version.string > [1] "R version 2.6.0 (2007-10-03)" > >> >> >> sDB_un<- "scott" >> sDB_pwd<- "tiger" >> >> >> Oracle() > An object of class "OraDriver" > Slot "Id": > [1] 1952 > >> dbDriver("Oracle") > An object of class "OraDriver" > Slot "Id": > [1] 1952 > >> >> Ora<- dbDriver("Oracle") >> Con <- dbConnect(Ora, user = sDB_un, passwd = sDB_pwd) > Error in function (classes, fdef, mtable) : > unable to find an inherited method for function "dbConnect", for > signature "OraDriver" >> > > ______________________________________________ > R-help at r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. >-- 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 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595
Hello and thanks for the quick reply. I got it here, http://stat.bell-labs.com/RS-DBI/download/index.html As the following site http://cran.r-project.org/web/packages/ROracle/NEWS mentions that the changes to the newest version are trivial. Although I take your point that package could be expecting R code that has since changed. Whilst I can happily code in R the make file, Makefile.win, for Version 0.5-9 is a bit beyond me. I'm not really a C++ expert. I don't suppose you or the wider R community have the binary for version 0.5-9? According to the readme for the package http://cran.r-project.org/bin/windows/contrib/r-release/ReadMe "Building binary versions of the contributed packages on CRAN has been automated. Binary packages will be available on CRAN about 1-3 days after the sources have been published." But I can't find any. All I want to do is kick off a stored procedure in an Oracle database, I think it might be easier to go through rJava. I don't want to quite give up just yet, on the elegant direct approach. Thanks in advance Sean -----Original Message----- From: Prof Brian Ripley [mailto:ripley at stats.ox.ac.uk] Sent: 23 April 2008 14:01 To: Creighton, Sean [CMB-FICC] Cc: r-help at r-project.org Subject: Re: [R] ROracle error at step 1 Where did you get your ROracle package from?> Built: R 2.2.1; i386-pc-mingw32; 2006-02-13 18:05:59; windowsindicates it was too old. All methods-using packages need to have been installed recently, and definitely since 2.4.0. (It is unsafe to use one that has not been installed for the same 'y' in 2.y.z because of its propensity for extracting bits of the R under which the package was installed.) So 'step 1' is to install ROracle from the sources. On Wed, 23 Apr 2008, Creighton, Sean wrote:> Hi > > I Can't connect to the Oracle database, any tips? Has anybody actually > got ROracle up and running on windows? > > >> unable to find an inherited method for function "dbConnect", > for signature "OraDriver" > > I can happily connect to the same database through RODBC. Oracleclient,> version 9.2 installed, amongst others. > > Sean > > > > > >> library(DBI) >> library(ROracle) >> >> packageDescription("ROracle") > Package: ROracle > Version: 0.5-7 > Date: 2006-02-13 > Title: Oracle database interface for R > Author: David A. James <dj at bell-labs.com> Jake Luciani > <jakeluciani at yahoo.com> > Maintainer: David A. James <dj at bell-labs.com> > Description: Oracle database interface (DBI) driver for R. This is a > DBI-compliant Oracle driver based on the ProC/C++ embedded SQL. It > implements the DBI version 0.1-8 plus one extension. > SaveImage: yes > Depends: R (>= 2.0.0), methods, DBI (>= 0.1-8) > License: LGPL version 2 or newer > URL: http://stat.bell-labs.com/RS-DBI http://www.omegahat.org > Packaged: Mon Feb 13 18:05:55 2006; dj > Built: R 2.2.1; i386-pc-mingw32; 2006-02-13 18:05:59; windows > > -- File: C:/PROGRA~1/R/R-26~1.0/library/ROracle/DESCRIPTION >> packageDescription("DBI") > Package: DBI > Version: 0.2-4 > Title: R Database Interface > Author: R Special Interest Group on Databases (R-SIG-DB) > Maintainer: David A. James <daj025 at gmail.com> > Depends: R (>= 2.3.0), methods > Imports: methods > Description: A database interface (DBI) definition for communication > between R and relational database management systems. All classes in > this package are virtual and need to be extended by the various > R/DBMS implementations. > LazyLoad: yes > License: LGPL (version 2 or later) > Collate: DBI.R Util.R zzz.R > Packaged: Tue Oct 16 21:43:31 2007; dj > Built: R 2.6.0; ; 2007-10-17 12:21:14; windows > > -- File: C:/PROGRA~1/R/R-26~1.0/library/DBI/DESCRIPTION >> >> R.Version() > $platform > [1] "i386-pc-mingw32" > > $arch > [1] "i386" > > $os > [1] "mingw32" > > $system > [1] "i386, mingw32" > > $status > [1] "" > > $major > [1] "2" > > $minor > [1] "6.0" > > $year > [1] "2007" > > $month > [1] "10" > > $day > [1] "03" > > $`svn rev` > [1] "43063" > > $language > [1] "R" > > $version.string > [1] "R version 2.6.0 (2007-10-03)" > >> >> >> sDB_un<- "scott" >> sDB_pwd<- "tiger" >> >> >> Oracle() > An object of class "OraDriver" > Slot "Id": > [1] 1952 > >> dbDriver("Oracle") > An object of class "OraDriver" > Slot "Id": > [1] 1952 > >> >> Ora<- dbDriver("Oracle") >> Con <- dbConnect(Ora, user = sDB_un, passwd = sDB_pwd) > Error in function (classes, fdef, mtable) : > unable to find an inherited method for function "dbConnect", for > signature "OraDriver" >> > > ______________________________________________ > R-help at r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guidehttp://www.R-project.org/posting-guide.html> and provide commented, minimal, self-contained, reproducible code. >-- 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 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595