similar to: Is it possible to de-select with sqlQuery from the RODBC library?

Dear R-list, I am trying to import (all) frames from a Microsoft Access database as individual data frames in a fancy loop, but I'm having troubles figuring out how to use the 'sqlFetch' from the RODBS package in a loop (mostly because I can't figure out how to loop over elements (I came from stata) I would very much appreciate if anyone on the list could help me solve this

Hola a tod en s, Tengo un problema a la hora de conectar una base de datos (*.mdb) de Access a RStudio utilizando windows 64-bit. Con el paquete RODBC utilizo el siguiente script que devuelve el error que indico: mdbConnect <- odbcConnectAccess("C:/Users/database.mdb") Error in odbcConnectAccess("C:/Users/Isa/FPI-AZTI/JUVENA/Databases/MEGASCOPE_JUVENA2014.mdb") :

Hi All, Can anyone please suggest me from where should I start to learn about 'how to connect to access db' ? How if someone has some written code and I can go over that to understand and make necessary changes... any help would be highly appreciated, -- Xin Ge. [[alternative HTML version deleted]]

Hello, does anyone know how I would go about getting R to connect to OpenOffice's Base program (OOo's version of MS Access) such that I can retrieve data from the database and perform calculations and data analysis? I'm totally new to R and Base and I've looked at some documentation, but found only examples for R connecting to PostgreSQL and MySQL, but nothing for OOo's Base

Hi, I want to import some data from Access and I am using the following codes: testdb <- file.path("c/../db1") channel <- odbcConnect("testdb") sqlFetch(channel,"tbl",colnames = TRUE, rownames = FALSE) It comes out the error message: 1: [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not found and no default

Hi all, In the code below I don''t understand: 1. Why I have to prepend overriden method content_columns with "self." to get it working? 2. Why column_for_attribute method is not working (no such method?) even if SomeTable is subclass of ActiveRecord::Base which have public column_for_attribute method? > class SomeTable < ActiveRecord::Base > > def

Hi, Version info: R: 1.5.1 RODBC: 0.8.3 Oracle: 8.1.7 unixODBC: 2.2.2 Easysoft ODBC driver: 1.0.0.6 SunOS/Solaris: 5.7 I'm trying to get RODBC working with Oracle on Solaris. I've installed unixODBC and the Easysoft ODBC driver. There are no problems connecting to the DB and executing queries using unixODBC's isql interactive client. Using R and RODBC however, I can open a connection

Hello, My questions are meant to be not necessarily specific...I am looking for advice and best practices for setting up an R environment. Here's my situation: I am one of perhaps three or four individuals who will be analyzing the same data through the use of R. I would like to set up a "base" environment for our project, basically some scripts that connect to a database, load

Hi, I'm running Rgui v2.4.0, RODBC v1.1-8, and psqlODBC v8.2.0002. Whenever I do the following chan <- odbcConnect("mydatabase", uid="admin") # connection to a postgresql db on a linux box tmp <- sqlQuery(chan, "select * from sometable;") # this is successfull odbcClose(chan) # this crashes Rgui and raises an error window containing the following MS error

Hi All, I am running into what appears to be character size limit in a JSON string when trying retrieve data from either `curlPerform()` or `getURL()`. Here is non-reproducible code [1], but it should shed some light on the problem. # Note that .base.url is the basic url for the API, q is a query, user # is specified, etc. session = getCurlHandle() curl.opts <- list(userpwd

1) installation is not as smooth as some other plug-ins. If you follow the instructions on http://www.kanthak.net/opensource/file_column/ it makes a directory called trunk instead of file_column. You have to manually rename it to file_column. I guess this is a minor annoyance but it gives me the feeling that things aren''t quite like other plugins. 2) I get this error: undefined

Hello, There are 3 PRI's connected to the card each from different operators. Especially echo occured on span 3 is really annoying. Configuration files are as follows. Is there something wrong in conf ? Zapata.conf -------------------------- [channels] context=default switchtype=euroisdn usecallerid=yes hidecallerid=no callwaiting=yes usecallingpres=yes callwaitingcallerid=yes

Hi Folks, BackgrounDRb is a Ruby job server and scheduler. Its main intent is to be used with Ruby on Rails applications for offloading long-running tasks. Since a Rails application blocks while serving a request it is best to move long-running tasks off into a background process that is divorced from http request/response cycle. This new release of BackgrounDRb is also modular and can be used

Dear all great developers. I wonder if there is any work being done or thoughts being shared regarding prepared SQL statements. Currently I am in heavy need of tuning SQL INSERTS that insert large (3MB) images into blobs. I am using rails 2.3.5 with postgres adapter and pg driver. Any information would be appreciated. Jarl -- You received this message because you are subscribed to the