Re: [R] ROracle error at step 1

From: Prof Brian Ripley <ripley_at_stats.ox.ac.uk>
Date: Wed, 23 Apr 2008 14:01:13 +0100 (BST)

Where did you get your ROracle package from?

> Built: R 2.2.1; i386-pc-mingw32; 2006-02-13 18:05:59; windows

indicates 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

______________________________________________
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.
Received on Wed 23 Apr 2008 - 13:21:08 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Wed 23 Apr 2008 - 13:30:30 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive