search for: dbdriver

...intended, an rpm was created and installed without any not fixable issue. After installing my bacula rpm I run a test to see if all works as expected. After bacula-dir and bacula-sd configuration I run bacula-dir -t to check error in config file and get this message: bacula-dir: dird.c:1206-0 Dbdriver field within director config file "dbi:PostgreSQL" mismatched with the Database argument "PostgreSQL" passed during Bacula compilation. I don't know what it is referring because I don't pass any argument like "PostgreSQL" during configure. The only option a...

List, Last week with the help of Uwe and some other folks I was able to get RMySQL 0.5-7 compiled against R 2.4.1 and MySQL 5.0.27. It was working fine--I was able to send select queries to the db, put the results in a data frame, and so forth. Today, dbDriver() threw an error: > dbDriver(MySQL) Error in function (classes, fdef, mtable) : unable to find an inherited method for function "dbDriver", for signature "function" There have been no system changes that should concern MySQL, R, or the installed package RMySQL (th...

...installed without any > not fixable issue. > > After installing my bacula rpm I run a test to see if all works as > expected. After bacula-dir and bacula-sd configuration I run > bacula-dir -t to check error in config file and get this message: > > bacula-dir: dird.c:1206-0 Dbdriver field within director config file > "dbi:PostgreSQL" mismatched with the Database argument "PostgreSQL" > passed during Bacula compilation. > > I don't know what it is referring because I don't pass any argument > like "PostgreSQL" during conf...

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 "ODBC" for &quot...

...es in the default installation. Somehow the function '.valueClassTest' which is defined on package 'methods', is not being defined. To ilustrate how this breaks DBI, try this in a 1.8.0 R install (with DBI installed): > library(DBI) > con <- dbConnect(dbDriver("MySQL"), dbname = "test") Error in dbConnect(dbDriver("MySQL"), dbname = "test") : couldn't find function ".valueClassTest" A dirty fix would be defining it by hand (from src/library/methods/R/RMethodUtils.R) : .valueClassT...

...Regarding checking the path without actually attaching the package to the search path, is there something better than "package:zoo" %in% search() or is that the best way? 4/ I have a function in a package that Depends on DBI and suggests RMySQL, RPostgreSQL, RSQLite. The function uses dbDriver() in DBI which uses do.call(). If I use requireNamespace() in place of require() I get > requireNamespace("RMySQL") Loading required namespace: RMySQL > m <- dbDriver("MySQL") Error in do.call(as.character(drvName), list(...)) : could not find function "MySQ...

Hi all, This is a potentially very stupid question about MySQL <-> R interaction, but I have not been able to solve it. I'm just trying to connect R to my MySQL databse, and gets this: > library(RMySQL) Loading required package: methods > m <- dbDriver("MySQL") > con <- dbConnect(m,group="testdb") Process R segmentation fault at Wed Oct 16 07:04:30 2002 My .my.conf contains this: [client] user = zak host = localhost password=<something> [rs-dbi] database = sdata [testdb] host = localhost database = testDB and...

Dear r helpers, At first, I apologize for raising a query which seems to be a stupid interpretation on my part. I am trying to learn SQLite. Following is an example given in the RSQLite.zip file (Page # 4) drv <- dbDriver("SQLite") tfile <- tempfile() con <- dbConnect(drv, dbname = tfile) data(USArrests) dbWriteTable(con, "arrests", USArrests) On the similar line I am trying to read my data. Suppose I have a dataframe as given below. DF = data.frame(X = c("US", "UK",...

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 ".valueClassTest" (This is my first attempt to access a an rdms from R, so I could be doing something else wrong.) Any ideas as what might be...

...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") : couldn't find function ".valueClassTest" What did I do wrong? Thanks in advance. Jeff. [[alternative HTML version deleted]]

...possible to create a DBMS connection automatically on startup of R? (Making sure of course that the db server has been started...) I am running MySQL on Mac OS X 10.4.2 with R2.4.1. I have tried to write a function using the RMySQL commands (below) and place them in .First of .RProfile: drv <- dbDriver("MySQL") dbcon <- dbConnect(drv, {other parameters present in my.cnf file} dbname="mydbName") DOES create a connection when entered into my R console individually but NOT when I place them in a function, i.e., condb <- function() { drv <- dbDriver("MySQL")...

...transcript showing one such error: ========================================================== R version 2.15.0 (2012-03-30) [...] > packageVersion('RPostgreSQL') [1] 0.3.2 > packageVersion('RSQLite') [1] 0.11.1 > library(RPostgreSQL) Loading required package: DBI > dbDriver('PostgreSQL') <PostgreSQLDriver:(32540)> > library(RSQLite) > dbDriver('PostgreSQL') Error in function (classes, fdef, mtable) : unable to find an inherited method for function "show", for signature "PostgreSQLDriver" =============================...

Hello, I installed RGui 2.5.1 and package DBI on Windows XP and tried to connect to Oracle database which is on a Linux server. When I tried to use dbDriver("Oracle"), I got an error as follows: > drv <- dbDriver("Oracle") Error in do.call(as.character(drvName), list(...)) : could not find function "Oracle" > Could anyone tell me how to connect to Oracle with R from Windows XP? Do I need to co...

...args='--enable-extralibs' --enable-oracle32=no ~/tmp/ROracle_0.5-5.tar.gz #since we have 64bit Oracle9i instalation PROBLEM: after executing simple statement, from within R, "fetch" function gives me the empty dataframe: ### CONNECTION, and SQL QUERY EXECUTION > ora <- dbDriver("Oracle") > con <- dbConnect(ora, "rado/only2admin" > dbListTables(con) character(0) > rs <- dbSendQuery(con, "desc * from si_r where id=498") > d <- fetch(rs, n= -1) > dim(d) [1] 0 3 str(d) data.frame': 0 obs. of 3 variables: $ ID :...

Dear list, I learned how to connect R to a local MySQL server, using: drv <- dbDriver("MySQL") con <- dbConnect(drv, user="root", password="mypass", dbname="mydb") Is it possible to connect R in this way to an external server (on a different machine, with a different IP)? I read the documentation on ?dbConnect (and everything I could fin...

...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 required package: DBI [1] TRUE > m <- dbDriver("MySQL") # or m <- dbDriver("SQLite") > con <- dbConnect(m, dbname="test") > dbGetQuery(con, "create table zzz ( + vintage VARCHAR(20) NOT NULL, + alias VARCHAR(20) default NULL, + Documentation TEXT, + PRIMARY KEY (vintag...

for the moment, I'm using: .onAttach <- function(libname, pkgname) { .bbg.db.conn <<- dbConnect(dbDriver("PostgreSQL"), user="blah","blah") } .onUnload <- function(libpath) { dbDisconnect(.bbg.db.conn) } which results in a hidden global variable in the global environment. I would prefer to make the assignment only in the package namespace. I've looked at as...

...[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 functi...

...9;t have much experience with R, reason why I use the R-GUI (version 2.5.1) on Windows. I have some problems with DBI package, I want to connect to PostgreSQL database but I don't know the way to do it. I was reading the DBI manual and I tried write in my R Console the next command: pg <- dbDriver("PostgreSQL") But R says: Error en do.call(as.character(drvName), list(...)) : no se pudo encontrar la función "PostgreSQL" I don't know what's happen, I would like to receive some help about this topic, I was looking for in the internet but there'...

Hi, I'm having trouble connecting to my postgreSQL db on Heroku(Amazon) using RPostgreSQL. I've looked through GitHub for people doing the same thing. There are quite a few examples and all look similar to the below: drv <- dbDriver("PostgreSQL") con <- dbConnect( drv, dbname = "dadqn30er7ghpl", host = "ec2-27-837-167-90.eu-west-1.compute.amazonaws.com", port = 5432, user = "tascofyvasswmblc", password = XXXXXX' ); I...