search for: oradriver

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 interf...

...em? I just begin to learn how to connect my Oracle database with R. > library(DBI) > library(ROracle) Warning message: DLL attempted to change FPU control word from 8001f to 9001f > ora=dbDriver("Oracle") Error in initialize(value, ...) : Invalid names for slots of class OraDriver: Id > My system is: Windows 2000, Oracle 9.2 R1.9.0 Thank you very much andi ---------------------------------------------------------------------------------------------------------------- Andreas Felber Swiss Federal Institute for Snow and Avalanche Research Fl??elastrasse 11 CH-7260 D...

...der Windows. I run R-2.3.1. I got the Windows binaries for ROracle from http://stat.bell-labs.com/RS-DBI/download/index.html Here is my session: > require(ROracle) Loading required package: ROracle Loading required package: DBI [1] TRUE > drv <- dbDriver("Oracle") > drv <OraDriver:(1648)> > con <- dbConnect(drv, user="USER", password="PASS", dbname="TEST") A window pops up, with the message: The instruction at "0x6260c621" referenced memory at "0x4a280ae2". The memory could not be read. And R freezes. Something...

...acle for Oracle version 9.2. When I am trying to use it with Oracle 10g I get the following error: con <- dbConnect(drv, "user/passwd at dbname"); Error in function (classes, fdef, mtable) : unable to find an inherited method for function "dbConnect", for signature "OraDriver" I then decided to compile ROracle myself. I downloaded ROracle src from below: http://cran.r-project.org/web/packages/ROracle/index.html When I was following the build instructions to run the makefile Makefile.win I got the following error: NMAKE : fatal error U1073: don't know...

...a.frame': 0 obs. of 3 variables: $ ID : int $ DAY: chr $ R : num #### seems like connections has been established > dbGetInfo(ora) $drvName [1] "Oracle (ProC/C++)" $connectionIds $connectionIds[[1]] <OraConnection:(14939,0)> $fetch_default_rec [1] 500 $managerId <OraDriver:(14939)> $length [1] 10 $num_con [1] 1 $counter [1] 1 $clientVersion [1] "0.5-4" Maybe it is something stupid (and I need just a hint), or may be it is something major. Thanks in advance, Rado Bonk -- Dr. Radoslav Bonk European Commission - DG Joint Research Centre (JRC) Ins...

...he database seems to work also. My problem is when I am selection rows that really exist in the database, it is returning nothing. Where should I look to see what could be my problem? Thank you very much, Mathieu > drv <- dbDriver("Oracle") > summary(drv, verbose=TRUE) <OraDriver:(6721)> Driver name: Oracle (ProC/C++) Max connections: 10 Conn. processed: 8 Default records per fetch: 500 Oracle R/S client version: 0.5-4 RS-DBI version: 0.1-9 Open connections: 2 1 <OraConnection:(6721,0)> 2 <OraConnection:(6721,7)> > > conn &l...

I am having difficulty using in 1.8.0 an object created under 1.7.1. The following is a 'minimal example' of the issue. First the part in 1.7.1: > require("methods") [1] TRUE > setClass("foo",representation("vector",label="character")) [1] "foo" > x <- new("foo",1:2,label=LETTERS[1:2]) >

...ta.frame': 0 obs. of 3 variables: $ ID : int $ DAY: chr $ R : num #### seems like connection has been established > dbGetInfo(ora) $drvName [1] "Oracle (ProC/C++)" $connectionIds $connectionIds[[1]] <OraConnection:(14939,0)> $fetch_default_rec [1] 500 $managerId <OraDriver:(14939)> $length [1] 10 $num_con [1] 1 $counter [1] 1 $clientVersion [1] "0.5-4" Maybe it is something stupid (and I need just a hint), or may be it is something major. Thanks in advance, Rado Bonk -- Dr. Radoslav Bonk European Commission - DG Joint Research Centre (JRC) Inst...

...se, it is returning nothing. Where > should I look to > > see what could be my problem? > > > > Thank you very much, > > Mathieu > > > > > >> drv <- dbDriver("Oracle") > >> summary(drv, verbose=TRUE) > >> > > <OraDriver:(6721)> > > Driver name: Oracle (ProC/C++) > > Max connections: 10 > > Conn. processed: 8 > > Default records per fetch: 500 > > Oracle R/S client version: 0.5-4 > > RS-DBI version: 0.1-9 > > Open connections: 2 > > 1 <OraC...

...n for "print" in "ROracle" ** help >>> Building/Updating help pages for package 'ROracle' Formats: text html latex example DBIPreparedStatement-class text html latex example OraConnection-class text html latex example OraDriver-class text html latex example OraObject-class text html latex example OraPreparedStatement-class text html latex example OraResult-class text html latex example Oracle text...

...y >Oracle database with R. > >> library(DBI) > >> library(ROracle) >Warning message: >DLL attempted to change FPU control word from 8001f to >9001f > >> ora=dbDriver("Oracle") >Error in initialize(value, ...) : Invalid names for >slots of class OraDriver: Id >> > > >My system is: > >Window XP, >Oracle 9.2 >R1.9.0 > >Thank you very much > >Xianghe > >Celera Genomics > > > >------------------------------ > >Message: 9 >Date: Sat, 14 Aug 2004 20:34:21 +0200 >From: Christoph Lehmann &...