search for: dbconnect

Hi, I'm trying to use R's DBI interface but it appears to be broken. I am using R 1.8.0 on Linux, and have just installed DBI 0.1-6 through the command 'install.packages("DBI")'. Installation went fine, but now when I try to do a simple dbConnect(), it won't do anything besides complaining about an internal error: > library(DBI) > dbConnect(anything) Error in dbConnect(anything) : couldn't find function ".valueClassTest" > dbConnect standardGeneric for "dbConnect" defined from package "DBI&qu...

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 argument(s) (address = "10.1.16.40") > con <- dbConnect(m, username="myname", password="mwpwd&q...

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 /lib/libc.so.6 (gd...

...I wanted to try some tests myself, but I cannot get Rdbi to connect to my ODBC database. Here is what works for RODBC for my setup: conn <- odbcConnect("xf", "xfl2", "xfl2") Now for Rdbi the documentation is lacking. "?Rdbi" doesn't work and "?dbConnect" gives little detail and no examples. I tried all of the following without success: conn <- dbConnect("ODBC()", dbname="xf", user="xfl2", password="xfl2") conn <- dbConnect("ODBC", dbname="xf", user="xfl2", password=&...

...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) * * * * #Fetching exact sub group names* * sub_grp_exact_num<-getSbGrpExactNum(con)* * sub_grp_exact_num_data<-sub_grp_exact_num$matrix* * sub_grp_exact_num_data_size<-sub_grp_exact_num$dim*...

...rsion * *DBI "0.1-11" * *RMySQL "0.5-11" * * * *MySQL version: 5.0.32* *A small R- program* *also doesn't run now*,whereas with these same configurations,i ran correlation analysis,regression analysis for my datasets. Now if i do this :--- *library(RMySQL) myDbconnect<-function(dbName,hostName) { print("myDbconnect print before driver") drv<-MySQL() #print(drv) print("myDbconnect print after driver") #con <- dbConnect(drv, user="xyz", password="xyz",dbname = dbName, host = hostName) con<...

Hello, I have a problem.. I'm trying to make R communicate with MySQL, but I always receive an error.. My code is: library(DBI) library(RMySQL) drv <- dbDriver("MySQL") conn<-dbConnect(drv,username="####",password="####",dbname="prova",host="localhost") and I receive this message: Errore in function (classes, fdef, mtable) : unable to find an inherited method for function "dbConnect", for signature "MySQLDriver&quo...

Hi everybody, I'm having a problem with connecting to my MySQL database. Each time I try to connect library(RMySQL) m <- dbDriver("MySQL") con <- dbConnect (m, host="my_host",username="my_username", password="my_password", dbname="name_of_db") it says Fehler in mysqlNewConnection(drv, ...) : RS-DBI driver: (could not connect my_host on dbname "name_of_db" Error:Can't connect to MySQL server...

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 find on the internet), but I failed to fi...

...4887123C99C4C6B57 | Y | Y | +------+-------+-------------------------------------------+-------------+-------------+ 2 rows in set (0.00 sec) But when I run the following: > library(RMySQL) Loading required package: DBI > drv = dbDriver("MySQL") > con = dbConnect(drv, user="adick", password = "***", dbname="***", host="***") Error in mysqlNewConnection(drv, ...) : RS-DBI driver: (Failed to connect to database: Error: Access denied for user 'adick'@'host' (using password: YES) ) Further, this erro...

...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 following command: R CMD INSTALL --configure-args='--enable-extralibs="-lsqlplus"' ROracle_0.5-4.tar.gz When I run R, I get a Segmentation fault after the dbConnect call: > library('ROracle') > ora <- Oracle() > con <- dbConnect(ora, "username/password at database") Segmentation fault (core dumped) Has anyone run into this, or are running the same configuration? Any help would be appreciated. Thanks, Mark Threefoot mark.th...

...acle32=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 : int $ DAY: chr $ R : num #### seems like co...

Estimados Anteriormente usé sin problemas Rsqlite, pero encuentro un error, comparto el código ¿alguno tiene idea sobre que puede llegar a ser? library(RSQLite) con <- dbConnect('SQLite', dbname='/Users/Javier_2/Desktop/SQLiteJavier.db') // o ? en lugar de ? , el error persiste > con <- dbConnect("SQLite", dbname="~/Users/Javier_2/Desktop/SQLiteJavier.db") Error in (function (classes, fdef, mtable) : unable to find an inherited...

...methods for database access. The packages is called "Rdbi." It borrows as much as possible from existing database packages / proposals. I'd like to start a discussion about the proposed interface. Here's what I've come up with so far: # # Rdbi: connectionMethods.R # dbConnect <- function(dbObj, ...) UseMethod("dbConnect") # # dbObj should be generated by an implementation defined function, # e.g., RPgSQL(), which returns a object with an approprite class # name, e.g., "PostgreSQL" or "MySQL". The implementation then # provides a method...

...> Hi > I run Linux SuSE 9.1, with MSQL 4.0.18 > I installed R 2.0.1 and it is working fine > I installed RM 0.5-5 package and verified all installed.packages (see > below) but when I tried to use any RMySQL specific comand is gives me > the same error messages > > > dbConnect > Error: Object "dbConnect" not found > > It looks like the packages is not installed > > Any ideas or help would be welcome > Thanks, > Popolito > > *** INSTALL ***** > ginossauro:/home/avonsydow/Download/Stats # R CMD INSTALL > RMySQL_0.5-5.tar.gz &...

..., that comes 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) : .va...

Hi, useR- In RMySQL, how do I overwrite records? (equivalent to "replace" query). For example, suppose that dat2 is a newer data.frame than dat1. con <- dbConnect(MySQL()) res <- dbWriteTable(con, "DBname", dat1, row.names=F, append=T, replace=T) res <- dbWriteTable(con, "DBname", dat2, row.names=F, append=T, replace=T) This would not update/replace the dat1 records in "DBname" with newer records from dat2. How would yo...

I want to share everything about a model except the db connection. Is this a reasonable way to do it? module NotebookDefinition -- Posted via http://www.ruby-forum.com/.

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", "Canada", "Australia", "Newzealand&qu...

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: 200...