search for: dbiconnection

(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 required package: DBI [1] TRUE > m <- dbDriver("MySQL") # or m <- dbDriver("SQLi...

...mplaining 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" defined with value class: "DBIConnection" function (drv, ...) .valueClassTest(standardGeneric("dbConnect"), "DBIConnection", "dbConnect") <environment: 0x91201a8> Methods may be defined for arguments: drv Anyone has a clue on what might be going on? Is it DBI working for any of you u...

...39;auto_copy.tbl_cube', 'auto_copy.tbl_df', 'cbind.grouped_df', 'collapse.data.frame', 'collect.data.frame', 'common_by.NULL', 'common_by.character', 'common_by.default', 'common_by.list', 'compute.data.frame', 'copy_to.DBIConnection', 'copy_to.src_local', 'default_missing.data.frame', 'default_missing.default', 'dim.tbl_cube', 'distinct.data.frame', 'distinct.default', 'distinct.grouped_df', 'distinct.tbl_df', 'distinct_.data.frame', 'distinct_.gro...

...t mapped' Traceback: 1: .Call("RS_MySQL_newConnection", drvId, con.params, groups, default.file, PACKAGE = .MySQLPkgName) 2: mysqlNewConnection(drv, ...) 3: .class1(object) 4: .class1(object) 5: is(object, Cl) 6: .valueClassTest(standardGeneric("dbConnect"), "DBIConnection", "dbConnect") 7: dbConnect(drv, user = "xyz", password = "xyz", dbname = dbName, host = hostName) 8: myDbconnect(dbName, hostName) 9: main() 10: eval.with.vis(expr, envir, enclos) 11: eval.with.vis(ei, envir) 12: source("sample.R") Possible acti...

...*** address (nil), cause 'memory not mapped' Traceback: 1: .Call("RS_Ora_newConnection", drvId, con.params, max.results, PACKAGE = .OraPkgName) 2: oraNewConnection(drv, ...) 3: is(object, Cl) 4: is(object, Cl) 5: .valueClassTest(standardGeneric("dbConnect"), "DBIConnection", "dbConnect") 6: dbConnect(m,...... [[alternative HTML version deleted]]

...ceback:* * 1: .Call("RS_MySQL_newConnection", drvId, con.params, groups, default.file, PACKAGE = .MySQLPkgName)* * 2: mysqlNewConnection(drv, ...)* * 3: .class1(object)* * 4: .class1(object)* * 5: is(object, Cl)* * 6: .valueClassTest(standardGeneric("dbConnect"), "DBIConnection", "dbConnect")* * 7: dbConnect(drv, user = "xyz", password = "xyz", dbname = dbName, host = hostName)* * 8: myDbconnect(dbName, hostName)* * 9: main()* *10: eval.with.vis(expr, envir, enclos)* *11: eval.with.vis(ei, envir)* *12: source("new_regressi...

...y not mapped' Traceback: 1: .Call("RS_MySQL_newConnection", drvId, con.params, groups, default.file, PACKAGE = .MySQLPkgName) 2: mysqlNewConnection(drv, ...) 3: .class1(object) 4: .class1(object) 5: is(object, Cl) 6: .valueClassTest(standardGeneric("dbConnect"), "DBIConnection", "dbConnect") 7: dbConnect(drv) Possible actions: 1: abort (with core dump) 2: normal R exit 3: exit R without saving workspace 4: exit R saving workspace Selection: It appears that it is crashing while handling an error relating to the database. If I give it parameters wh...

...as any other OpenDocument files, are ZIP archives containing the HSQL files. To establish the connection, the .odb file is unzipped via the "zip" bash command if available, and the connection is made via the RJDBC interface. The "odb" object produced inherits from the "DBIConnection" class, thus all functions provided in the DBI packages may be used directly on it to manage the database. The odb.read and odb.write functions are only wrappers to such DBI functions, handling frequent issues such as charset or factors considerations. Notice the database files are copied...

...as any other OpenDocument files, are ZIP archives containing the HSQL files. To establish the connection, the .odb file is unzipped via the "zip" bash command if available, and the connection is made via the RJDBC interface. The "odb" object produced inherits from the "DBIConnection" class, thus all functions provided in the DBI packages may be used directly on it to manage the database. The odb.read and odb.write functions are only wrappers to such DBI functions, handling frequent issues such as charset or factors considerations. Notice the database files are copied...

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

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: