[R] ROracle error at step 1

From: Creighton, Sean <sean.creighton_at_citi.com>
Date: Wed, 23 Apr 2008 13:38:46 +0100


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

$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. Received on Wed 23 Apr 2008 - 12:59:52 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 - 14:30:33 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