similar to: RODBC Error: 'getCharCE' must be called on a CHARSXP

I stumbled across one of those intermittent bugs where the code sometimes works and sometimes doesn't. Below is an example run showing a failure where a CHARSXP object was not properly created (by the sub function?). I was able to reproduce this error on three different R builds in fresh R sessions, but it sometimes takes a few start up R -> run code -> close R iterations for the

Dear list, I installed R 3.3.2 on a Red Hat Linux Enterprise 7.3 machine by adding the EPEL-repository and then installing it via yum. R starts up and seems to be doing fine at first sight. However, when I try to list the files in a directory with the command files <- list.files(path="/home/username/directory_name/", pattern="*.Rda",, full.names=T, recursive=FALSE) I get

On 23.08.2017 12:02, Braun, Stefan wrote: > Dear list, > > I installed R 3.3.2 on a Red Hat Linux Enterprise 7.3 machine by adding the EPEL-repository and then installing it via yum. > R starts up and seems to be doing fine at first sight. However, when I try to list the files in a directory with the command > > files <-

Hello, I am new to the RODBC package, but I have looked over the PDF as well as a few websites that go over the SQL language. I can connect to my database fine using >channel<-odbcConnect("Oracle ODBC") # then am prompted to enter my user id and password After that I'd like to use the odbcQuery function and the SQL statement: SELECT * FROM table_name WHERE SAMPLE_YEA LIKE

I am very new to R and have been struggling trying to read a basic ".csv" file from a password protected site with the following code: myURL ="http://www.frontierweather.com/degreedays/L15N15PowerRegionAverages_10weeks.txt" test2=read.table(url(myURL),header=TRUE,sep=",") A 'data.frame' is returned into the workspace, however it is not the data contained in

Dear all, I have some problems with importing data from an Access data base via RODBC to R. The data base contains several tables, which all are imported consecutively. One table has a column with column name "NO". If I run the code attached on the bottom of the mail I get no complain, but the column name (name of the respective vector of the data.frame) is "Expr1014" instead

Dear R users, I am trying to connect R to data that is in a Access Database but I have problem with the construction of queries using special characters. I am using RODBC package. The following is working : > MyQuery<-paste("SELECT first( (DateHeure) ) , avg(NNO3_AT322_OUT_moy) AS Cond FROM Colonne_3 ") > Col3<-sqlQuery(con, query=MyQuery) > Col3

Hello, I have list of 600K lists, each sublist a list of two elements, the first a character, the second a list of six named elements, some characters some numrics. LISTA (600K) (:= h) |__ List of two elements |__ Character |__ Named List of 6 elements (characters and numerics) This works, sip <- lapply(h,function(r) r[[2]][['sip']]) but I wish to unlist this

Hi, I had a technical question about CHARSXP and garbage collection and couldn't find the answer in the R manual. The question is this. Are CHARSXP garbage collected like any other object, despite being part of the CHARSXP cache? i.e. is the cache being cleaned by garbage collection regularly and therefore, when I am in C code, do I need to protect a CHARSXP? Thanks! Holger [[alternative

How do I return a character string with quotes inside string? For example, what logic do I use if I want to return the following: Test Score="A" I tried the following .... Score<-paste("Test Score=","A",sep='"') But it returned a "\" inside: "Test Score=\"A" Any assistance would be

I'm using list.files() on my home directory, like this: crnt.files <- list.files(dir.to.check, full.names=TRUE, all.files=TRUE, recursive=TRUE) With dir.to.check set to the full path to my home directory. After a while I get: Error in list.files(dir.to.check, full.names = TRUE, all.files = TRUE, : 'translateCharUTF8' must be called on a CHARSXP This happens on one of my

Dear R cracks I am trying to fetch 38 Tables from 38 ESRI Geodatabases through an ODBC connection. I stored the 38 channels in a list and the 38 tablenames in an other list. With a for(i in 1:38) .... sqlFetch(....) I try to read the tables into a third list. But always after a certain amount of rounds (mostly 16) i get Fehler in odbcQuery(channel, query, rows_at_time) : Calloc konnte

Dear R-SIG-Debian, while trying to query data from an SQLite database through RODBC on Debian testing, R crashes with the following message: library(RODBC) con3 <- odbcConnect("test3") # 'test3' being an ODBC datasource configured with SQLite3 driver, # but the same happens with SQLite driver sqlQuery(con3, "select * from test") # 'test' being any table

I'm trying to load Affy Annotation data from an Access database into R using RODBC. This has worked fine for quite some time. The bug seems to be correlated to RODBC versions 1.1-7 and later. Works fine: R 2.2.0 with RODBC 1.1-4; R 2.3.0 or R 2.4.1 with RODBC 1.1-6 Fails: R 2.3.1 with RDOBC 1.1-7; R 2.4.1 with RODC 1.1-7 or 1.1-8 Details ===== This works fine: Version 2.2.0

Hello all, I want to highlight a recent change in R-devel to the larger developeR community. As of r41495, R maintains a global cache of CHARSXPs such that each unique string is stored only once in memory. For many common use cases, such as dimnames of matrices and keys in environments, the result is a significant savings in memory (and time under some circumstances). A result of these changes

I have a Postgres database that I am connecting to with the Postgres ODBC driver on Windows XP in R 2.1.0. In the database is a database with two schemas (public and X). With RODBC (1.1-4) , I can connect to the database and get the tables with sqlTables(db). I can query tables in the schema with sqlQuery("SELECT * FROM X.test"). However, I can't get the columns in table X.test

I am getting segfaults when I try to read a large binary object from a SQL Server database via RODBC. I am using the FreeTDS ODBC driver, and it has been working fine when reading from this same database. I have included relevant parts of the session below. Each row of the v_MAFiles view holds a text, html or pdf version of a document. The FileType entry is one of TXT, PDF, or HTML. If

R 2.8.1 Ubuntu 64amd RODBC 1.2-5 --------------------------------- This was a hard-to-track bug for me, because sqlQuery() did not fail - instead, it looked like it returned some good data and some NA where there should have been numbers and 0 where there should have been NAs. I did: (a) sqlQuery( o, qry, as.is=TRUE, errors=TRUE, rows_at_time=1024 ); (b) sqlQuery( o, qry, as.is=TRUE,

Greetings -- in order to write back to SQL databases, one needs to create a dataframe with values. I can get column names of an existing table with sqlColumns. Say I have a vector of values (if they're all the same type), or a list (if different). How do I create a dataframe with column names given by my sqlColumns? To make it concrete, how do we make a dataframe A B C 1 2 3

Is there a way to get a table in a certain schema? The Oracle database I am using has a table by the same name in two different schemas. This creates problems in sqlUpdate because to sqlUpdate there are duplicate columns. The following is part of the output of sqlColumns: sqlColumns(eids, "TEST_ARTCL_INST")[,1:4] TABLE_CAT TABLE_SCHEM TABLE_NAME COLUMN_NAME 1