similar to: DBI Interface broken

Full_Name: Fernando Henrique Ferraz Pereira da Rosa Version: 1.8.0 OS: Linux 2.4.21 Submission from: (NULL) (200.206.211.169) After installing R 1.8.0, the R DBI interface stopped working. I tracked it down as a problem in the 'methods' package, that comes in the default installation. Somehow the function '.valueClassTest' which is defined on package 'methods',

Hi, i have R on ubuntu64 i got ROracle database connection issues as seen below at a loss do to what next > library(ROracle) Loading required package: DBI > m <- dbDriver("Oracle") > con <- dbConnect(m, username="EPICEDF", password="ps39000b", dbname="EPICD2007", address="10.1.16.40") Error in oraNewConnection(drv, ...) : unused

Hi All, Sorry to bother everyone again.Ofcourse Prof Ripley ,Yihui and Uwe had replied to my email.But this segmentation fault error was not solved.I agree with Prof Ripley,as he said my R and all other configurations,are very old.But what i don't understand is ,i was able to run analysis till few days before,and why suddenly this error. *The configuartions i use:---* *R-version * *>

(I am not sure if this is a bug or a request for a more understandable warning, or possible something obvious I should be posting on r-help.) I am trying to coerce an new class object to be a DBIConnection and it does not work the way I think it should: R version 2.5.1 (2007-06-27) ... > require("RMySQL") # or require("RSQLite") Loading required package: RMySQL Loading

Hi All, Can anyone help me please?I don't know much about segmentation faults.I understand what it is,but why my script's throwing the error i don't know. This is my main function:---- *main<-function()* *{* * dbName<-"xyz_database"* * hostName<-"xyz.com"* * con<-myDbconnect(dbName,hostName) * *

Since there doesn't appear to be an RMySQL rpm for SuSE 8.*, does anyone know if the 7.3 version will work with the SuSE 8.2 rpms of R and DBI? The package installs without complaint, but when I try to run con <- dbConnect(dbDriver("MySQL"),dbname="test") I get the error Error in dbConnect(dbDriver("MySQL")) : couldn't find function

Hi there. I see in a post from 2002 that you got the following problem with RMySQL: > con <- dbConnect(m) Process R segmentation fault at Wed Aug 28 08:21:11 2002 I have the same problem today: drv=dbDriver("MySQL") dbConnect(drv) # or with pretty much any other failing options Program received signal SIGSEGV, Segmentation fault. 0x00002b28d60c9fa0 in strlen () from

Hi, I recently upgraded to R 2.9.0 on linux x86. After doing so, I switched to the RPostgreSQL package for interfacing with a postgresql database. I am using postgresql 8.3.7. A query that works from the postgresql terminal is causing a segfault when executed from R. My sessionInfo, the error message, and the R code used to generate the error are listed below. I have noticed that a

Hi all, I would like the following code to work, but it doesn't: library(DBI) library(RODBC) m <- dbDriver("RODBC") # Example for dbConnect(DBI), causes error m <- dbDriver("ODBC") # Example for DBIDriver-class(DBI), causes error The errors are: Error in do.call(as.character(drvName), list(...)) : could not find function "RODBC" (substitute

Hi, I would like to be able to use R with a connection to a PostgreSQL database. I am using R 2.0.1 on windows XP. I have tried installing both the DBI and rDBI packages (which is better?) but in either case I run into the same problem - when i try to use either the dbDriver or dbConnect functions i'm told the function couldn't be found. Seems like the packages aren't installing

Hi, first thanks to Sunny Ho (and David James for the pointer) for resolving the problem of the empty rows returned from ROracle. However, I have a problem still: > library(ROracle) > ora <- dbDriver("Oracle") > con <- dbConnect(ora, user = USER, password = PWD, dbname = DBNAME) > rs <- dbExecStatement(con, "select * from USER_TABLES") Error in

Hi. I frequently use RMySQL package to interface R with MySQL databases. I was having a try with package DBI and I got the following error: > library(RMySQL) > library(DBI) > drv <- dbDriver("MySQL") > ch <- dbConnect(drv, dbname="mydb", user="myuser", password="mypasswd") > ibm <- dbGetQuery(ch,"select * from table where

According David Jame's response to my earlier question, there is a problem with setGeneric.setMethod in R 1.8.0 that affects DBI and RMySQL. Is there a fix for this? David Jame's refers to an 'R-patched version' but I haven't seen anything like this on CRAN. Would going back to an older version of R solve the problem? Thanks, Barnet Wagman "David James wrote:

I don't use MySQL but I have seen messages like this before. They often have replies which indicate that you need to follow the instructions more closely. I suggest you search the list for these previous posts as I'm sure there is help there, somewhere! Tom > -----Original Message----- > From: Adriano von Sydow [mailto:pdasilva at xtra.co.nz] > Sent: Thursday, 10 March 2005 5:13

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)

Double quotes are not legal SQL syntax. Use single quotes. -- Sent from my phone. Please excuse my brevity. On August 29, 2017 2:21:44 AM PDT, Eric Berger <ericjberger at gmail.com> wrote: >I have been successfully using RODBC for a long time (years) to connect >to >MS SQL Server from R. >This week I wanted to try using odbc but I am seeing some problems >which >may be

Hi all, For the R package bujar, the warnings below were generated on CRAN's Windows systems. The package uses some Fortran subroutines. I would appreciate any advice to eliminate the warnings. By the way, similar warnings were generated to some unrelated R packages as well: https://www.r-project.org/nosvn/R.check/r-oldrel-windows-ix86+x86_64/imputeTS-00check.html. Thanks in advance. Zhu

I am a newbie in R and want to use MySQL database. Here is what I have and done. R 1.8.0 mysql 4.0.16 Both running in Windows XP. I download the RMySQL.zip from the internet and used the Packages installer in the RGui to install RMySQL. I also installed DBI packages. I ran the following and got the error. > mgr<-dbDriver("MySQL") Error in dbDriver("MySQL") :

I have been successfully using RODBC for a long time (years) to connect to MS SQL Server from R. This week I wanted to try using odbc but I am seeing some problems which may be related to how I set up my driver and/or connection. The dbWriteTable manual page gives as an example command: dbWriteTable( pDB$con, "mtcars", mtcars[1:5,]) When I try this I get the following error Error:

Hello, I am trying to configure my system with ROracle. I am running RHEL 3 AS x86_64. I have the Oracle client 9.2.0.4 x86_64. I have successfully compiled and run both R-1.8.1 and R-1.9.0 (tried ROracle on both installations). I am using DBI 1.8 and ROracle 0.5-4. I have used both the default Redhat installed gcc 3.2.3 and gcc 3.4. I am able to compile ROracle successfully with the