search for: robdc

Hi Folks, I've been bumping my head against the 4GB limit for 32-bit R. I can't go to 64-bit R due to package compatibility issues (ROBDC - possible but painful, xlsReadWrite - not possible, and others). I have a number of big dataframes whose columns all sorts of data types - factor, character, integer, etc. I run and save models that keep copies of the modeled data inside the model objects as well (mle2 objects, to be specific)....

How can I have SQL queries (ODBB/Windows) return dates (cf text) for date columns? I can successfully query and ODBC database with R. I can subsequently convert the text representations of dates in columns using as.POSIXxx functions but I figured there must be a way to achieve this at the time of the query. Any tips? paul

I am using the following: library(RODBC) chan = odbcConnectExcel("rats-lda") rats.lda = sqlFetch(chan, "data") close(chan) And getting the following error message: > library(RODBC) Error in library(RODBC) : there is no package called ?RODBC? > chan = odbcConnectExcel("rats-lda") Error: could not find function "odbcConnectExcel" > rats.lda =

Buenas: A ver si te puede servir: 1.- Creo que ROBDC sólo corre en la versión de 32-bits, no en la de 64-bits. Para ello: 1.1 En R-Studio -> Tools -> Global Options -> General -> Change -> 1.2 Elegir version de 32-bits 1.3.a) Para que se produzca el cambio -> seleccionar la versión de 32-bits que eli...

...eyre <efreyre en movistar.es> Enviado: jueves, 31 de agosto de 2017 13:41 Para: 'Jesús Para Fernández'; 'Carlos Ortega'; 'Francisco Rodríguez' Cc: r-help-es en r-project.org Asunto: RE: [R-es] Conectar Access con R Buenas: A ver si te puede servir: 1.- Creo que ROBDC sólo corre en la versión de 32-bits, no en la de 64-bits. Para ello: 1.1 En R-Studio -> Tools -> Global Options -> General -> Change -> 1.2 Elegir version de 32-bits [cid:image003.jpg en 01D3225E.C92C4BF0] [cid:image011.jpg en 01D3225E.C92C4BF0] 1.3.a) Para qu...

All, I have used package.skeleton, edited the .Rd files and the DESCRIPTON file. In one of my package functions I am using RODBC so I have a line of code that reads: require(RODBC). In my DESCRIPTION file I have the following relevant line: Depends: R (>= 2.9.0), RODBC However, when I do a check (Rcmd check my_package_name) I get this warning: * checking for unstated dependencies in R code

De todas formas prueba a realizar la conexión de forma manual desde RStudio. Las últimas versiones (o al menos la Preview) incluyen una pestaña "Connections" con la que a través de un Wizard puedes configurar conexiones, entre ellas a ODBC y una de las opciones es "MS Access". Saludos, Carlos Ortega www.qualityexcellence.es El 31 de agosto de 2017, 12:11, Francisco Rodríguez

I am receiving an error when trying to connect to the Oracle Database using RODBC on a 64-bit Windows Server OS. The version of R is 2.10.0-win32.exe Is this the wrong version. Does RODBC only work with 32-bit ODBC drivers? 've read over all the posts and documentation manuals. The system is Windows Server 2003 with R 2.81. and the latest downloadable RODBC package. The Oracle SID/DSN is

Hey everyone, I don't have a question. Instead some helpful advice with things I've learned from trying to connect 'R' to databases using RODBC. ROBDC is a very handy tool that, once you have everything fixed up nicely, is a great way to have scripts run fairly autonomously, safe in the knowledge that data isn't accidentally messed up. But I was fairly ignorant about databases, and I suspect maybe some others out there are as well. 1) Conne...

Hi I have a question, as im not able to import a csv file which contains a big dataset(100.000 records) someone knows how many records R can handle without giving problems? What im facing when i try to import the file is that R generates more than 100.000 records and is very slow... thanks a lot!!!