search for: dbgetinfo

...meters 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") dbcon <- dbConnect(drv, dbname="mydbName") dbGetInfo(db) } When the function is called, the dbGetInfo(dbcon) does return connection info but no connection object is present. I would be ver grateful for any guidance on where I have gone wrong. Thank you. Mark Ruddy PhD student Geography Dept., Royal Holloway (University of London) Egham, UK. [[...

...lmysqlclient -lz -L/usr/lib64/R/lib -lR ** R ** inst ** save image Loading required package: DBI [1] "dbObjectId" [1] "format" [1] "show" [1] "print" [1] "MySQLObject" [1] "MySQLDriver" [1] "dbUnloadDriver" [1] "dbGetInfo" [1] "dbListConnections" [1] "summary" [1] "MySQLConnection" [1] "dbConnect" [1] "dbConnect" [1] "dbConnect" [1] "dbDisconnect" [1] "dbSendQuery" [1] "dbGetQuery" [1] "dbGetException"...

...R > ** inst > ** save image > Loading required package: DBI > [1] "dbObjectId" > [1] "format" > [1] "show" > [1] "print" > [1] "MySQLObject" > [1] "MySQLDriver" > [1] "dbUnloadDriver" > [1] "dbGetInfo" > [1] "dbListConnections" > [1] "summary" > [1] "MySQLConnection" > [1] "dbConnect" > [1] "dbConnect" > [1] "dbConnect" > [1] "dbDisconnect" > [1] "dbSendQuery" > [1] "dbGetQuery&qu...

...ctory and inserts line by line into a database... *** caught segfault *** address 0xc0000010, cause 'memory not mapped' Traceback: 1: .getGeneric(f, where, package) 2: getGeneric("coerce", where = where) 3: as(obj, "integer") 4: mysqlConnectionInfo(dbObj, ...) 5: dbGetInfo(conn, "rsId") 6: dbGetInfo(conn, "rsId") 7: dbListResults(con) 8: dbListResults(con) 9: mysqlQuickSQL(conn, statement, ...) 10: dbGetQuery(con, sql) 11: dbGetQuery(con, sql) 12: doTryCatch(return(expr), name, parentenv, handler) 13: tryCatchOne(expr, names, parentenv, handle...

...status creating src/Makevars ** libs make: `RMySQL.so' is up to date. ** R ** inst ** save image [1] TRUE [1] "dbObjectId" [1] "format" [1] "show" [1] "print" [1] "MySQLObject" [1] "MySQLDriver" [1] "dbUnloadDriver" [1] "dbGetInfo" [1] "dbListConnections" [1] "summary" [1] "MySQLConnection" [1] "dbConnect" [1] "dbConnect" [1] "dbConnect" [1] "dbDisconnect" [1] "dbSendQuery" [1] "dbGetQuery" [1] "dbGetException" [1] "...

...t; 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 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...

...;- dbSendQuery(con, "select * from si_r where id=498") ^^^^^^ CORRECTION > 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 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...

Greetings all, I am running R 2.5.1, RMySQL 0.6 , and DBI 0.2-3 on Windows XP Like others, I am having trouble with NA/Null value conversions between R and a MySQL database via DBI, but I could not find my exact problem in the archives. Most of the time NA values in R get transferred correctly to the database and back again, unless (apparently) if they are in the last column of the table being

...on or after line 24 dbDataType-methods text html latex example dbDriver-methods text html latex example dbEscapeStrings-methods text html latex example dbEscapeStrings text html latex example dbGetInfo-methods text html latex example dbListTables-methods text html latex example dbNextResult-methods text html latex example dbNextResult text html latex example dbObjectId-class...

...text html latex dbCommit-methods text html latex example dbConnect-methods text html latex example dbDataType-methods text html latex example dbDriver-methods text html latex example dbGetInfo-methods text html latex example dbListTables-methods text html latex example dbObjectId-class text html latex example dbPrepareStatement-methods text html latex example dbReadTable-methods text...

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