similar to: ms access --> mysql --> R in Linux

Hi again, I have played a little more with mdbtools and R. I downloaded the latest version of mdbtools from sourceforge (version 0.6pre1). Quickly scanning the mailing list suggests that ODBC seems to work with PHP but I have not been able to get it to work with R. I can make a connection to the database and when I do a query I get back the names of the rows but not the data. I must admit I have

Morning everyone, I was hoping to use mdbtools to extract data from some Access databases overnight. I have yum installed the tools from Dag and also downloaded and (eventually!) compiled the latest release from the mdbtools web site, but I either get 'buffer overflow' errors or no output from most of the tools. I have been trying to cvs checkout the latest development version but

@Work requires me to manipulate the MS Access database (mdb) file located on an XP box that is an integral part of a third party application that is central to the business. Does anyone have experience doing so? I have used odbtp in the recent past but it is extremely difficult to set up on the linux box as I learned when I recently upgraded from CentOS 4.x to 5.x. Is there another way to get

Hi, It's my first post on this group. I've just started learning & using R and I like it ;-) I have I think simple question. I'm trying to plot a histogram for my data set. My data set is defined as follows: Class N 12.5 3 17.5 10 22.5 12 27.5 8 32.5 7 37.5 3 42.5 4 47.5 2 Class means middle of set of my ranges I define. N column stores number of measurements counted to

I have a geodatabase and would like to import it into GRASS, but it is in .mbf. I use mac and linux, and don't have access to access on the machines that I normally use. I do have access to access at school, but I would like to find a way around this if possible. Any thoughts, comments, or suggestions would be welcome. thanks, -- Stephen Sefick Let's not spend our time and resources

I have an MS Access database with one table and one column holding rep(1:10) I use: library(RODBC) channel <- odbcConnect("test") sqlQuery(channel, paste("SELECT col FROM tblTest"), believeNRows=FALSE) and get: 49 50 51 52 53 54 55 56 57 12337 What? The above should, of course, read: 1 2 3 4 5 6 7 8 9 10 I tried the 'odbcQuery' /

I need to get read only access to a MDB database accessed from a Linux box using samba, anyone had any luck with this and know how to set it up? Please resist from posting your reasons why and MDB should not be used, I am the converted so stop preaching. The MDB is there to stay and I have to read to it. thanks -- Posted via http://www.ruby-forum.com/.

Hi, Is there is anyway to Open Microsoft .mdb files in open office on Centos 5.3 ? Thanks linux

Dear All, I am really far from a database expert (I do prefer flat files as long as that is reasonable), but I have to deal with an accdb database (Microsoft Access new format). It all stems from the fact that I run R almost exclusively on Debian platforms. I did a bit of googling http://r.789695.n4.nabble.com/How-to-load-data-from-accdb-into-R-td4656613.html

Hi, I am on a windows 2000 machine and want to use an ms access 97 database (*.mdb) as db backend. I did a clean install: ruby, gems, rails, odbc-rails. A test rails application connecting to a local mysql server is doing fine. I can also locally connect to the odbc connection "local_odbc_name" with the aqua data studio client. But now with rails. As soon as I change the adapter to

Our Samba file server has a share with an visual basic application, there are 8 XP clients working with this share. The problem is that connections are very slow when accessing mdb databases... we are using MS Access ODBC to connect to the database on the samba server. Is there any special tuning for make things better? Thanks for the posible answers... -- Javier Cano Flores

I have a microsoft database that I have read in that is a list of dataframes processed by mdb.get. I am trying to read this into GRASS gis and need to change the labled atomic vectors to double precision- especially the coord.x coord.y. Now is there a way to check for classes and then change them inside of a for loop. This is the code I am using at the moment. library(Hmisc) # Read all tables

Hi Greetings to all Is my first post in this forum sorry for my english Many compliment to all developers for great work in Wine Profili2 is the most famous Windows software for designe airfoil profile for RC airplane models. Some times ago I have installed it in ubuntu 10.10 by Wine(1.3.5) with success This software use an mdb file First I have installed Profili download in this web site

I have a file server running with Samba over Debian Sarge 3.1 R1. This File server store MDB and XLS files. Could anybody give me an optimal setup for my samba server (smb.conf). Actually, the performance is very poor. [global] workgroup = REVLON netbios name = FILE_SRV security = user encrypt passwords = yes passwd program = /usr/bin/passwd %u unix password sync = yes socket options =

If yes, how do I set it up in the yml file? Thanks. - amateur Railist -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060818/6690a4e2/attachment.html

Hola a todos, estoy intentendo cargar unos datos contenidos en una tabla de ACCESS, por lo que ejecuto los siguientes comandos dir<-"C:/Users/D/Desktop/" library(RODBC) cn<-odbcConnectAccess(paste(dir1,"datos.mdb",sep="")) pero me da el siguiente error Warning messages: 1: In odbcDriverConnect(con, ...) : [RODBC] ERROR: state IM002, code 0, message

Hi there, I have seen this post. https://stat.ethz.ch/pipermail/r-help/2007-June/133606.html have odbc installed in my machine. Now I have the following message: channel2 <- odbcDriverConnect("test.mdb")Warning messages:1: In odbcDriverConnect("test.mdb") : [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not found and no

I have a single Linux server running SuSE 9.1 and Samba 3.04. I have one share that has several MS Access tables on it. One user can operate just fine, however when a second+ user tries to access the same database tables, one of several things happens depending on what I have in the smb.conf file. It's usually a permission denied, or a "can't lock" type of error. When the

Buenas, Estoy usando R para conectarlo con ACCESS pero me da error: > conexion<-odbcConnect("ProductionReport.mdb") Warning messages: 1: In RODBC::odbcDriverConnect("DSN=ProductionReport.mdb") : [RODBC] ERROR: state IM002, code 0, message [Microsoft][Administrador de controladores ODBC] No se encuentra el nombre del origen de datos y no se especificó ningún