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 <[EMAIL PROTECTED]> Jake Luciani
<[EMAIL PROTECTED]>
Maintainer: David A. James <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]>
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@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.
