similar to: R and mysql on debian

Hi, I'm thankful for any help on installing RMySQL on Windows XP for R 1.9.1 The thread http://tolstoy.newcastle.edu.au/R/help/04/01/1021.html already tried to discuss the matter. It concludes that Windows Sources for Packages are alike the Linux ones. So I extracted the files from the RMySQL_*.tar.gz from http://stat.bell-labs.com/RS-DBI/download/index.html and stuffed them into a zip-file

I think I figured this out. I should not have put the Driver name in braces. Changing it from {MySQL} to MySQL seems to work. -----Original Message----- From: Marcus, Jeffrey Sent: Tuesday, January 12, 2010 6:09 PM To: 'r-help at r-project.org' Subject: Problems connecting with MySQL using odbcDriverConnect (RODBC package) on Linux I am sure I'm doing something wrong here but not

I'm using R on a Linux box: > version platform i686-pc-linux-gnu arch i686 os linux-gnu system i686, linux-gnu status major 1 minor 5.0 year 2002 month 04 day 29 language R I want to use data that is stored in a MySQL database.

Hi all, I have installed RODBC package. But am not able to connect it for using MySQL. For accessing MySQL Db a connector is required.For that can i use the mysql db which is a part of WAMP server or use separate mysql db. I know there is a package called RMySQL. But i find it very difficult to install the RMySQL package under .Which is better one for accessing MySQL Database. Thanks Amrita

Hi all, On a fresh CentOS 4.3 box, suddenly what should have took usually around 60 seconds, now it makes me wonder if I can still perform simple sysadmin tasks, or should I get a long vacantion... # yum groupinstall "MySQL Database" Repository update is listed more than once in the configuration Repository base is listed more than once in the configuration Repository addons is listed

Hi all, Unfortunately I must use winXP at my job, so I'm trying install from source RMySQL. Here are some details about this problem: - R 1.7.1 - RMySQL 0.5-2 - mysql 4.1.0-alpha-max-nt I followed the instructions posted in http://www.biostat.jhsph.edu/~kbroman/Rintro/Rwinpack.html and the following messages appeared. BTW, thanks in advance for your help and comments. C:\Program

Hello everybody, I have tried to connect to external databases (specifically, to a MS Access database in my computer) from R using the RODBC package. Unfortunatelly I haven't been able to do it, even if I 'followed' the instructions in the manual. COuld someone please help me? I have a MS Access database in my computer and I went to the control panel in order to create a DSN file

Dear List In my short life as a beginning R-user i've encountered a following problem that i'm unable to solve myself: I have a database in MySQL containing table and field names as well as some data containing Polish accentuated characters (like ????), utf8-encoded. It works just fine with just any external query browser i can find, jdbc, odbc, native, whatever. Also mysql is happy

I have a problem with some missing headers when trying to install RODBC on my linux box. > install.packages("RODBC", + lib="/usr/local/david/R") trying URL 'http://cran.stat.auckland.ac.nz/src/contrib/RODBC_1.3-1.tar.gz' Content type 'application/x-gzip' length 990220 bytes (967 Kb) opened URL

I have a mysql database I installed on my Ubuntu server, and I'm trying to figure out how to access and analyze it from a Win XP machine running R 2.15.1. I thought that RMySQL was the way to go. (Is there an easier way?) I tried to follow the instructions at http://www.r-bloggers.com/installing-the-rmysql-package-on-windows-7/ so I installed mysql-installer-community-5.5.27.0.msi, then set

I am having trouble installing RMySQL on a clean install of Fedora Core 4 64 bit on a dual dual core machine (that is, two dual core processors). Seems like the LD_LIBRARY_PATH is incorrect, but I don't seem to have it quite right yet. There are a few mentions of this problem in google, but thus far none of the "fixes" and fixed my problem. I've tried defining the

Hello: I am tried to install the RODBC package in debian etch. At the end of the installation it appears errors: ********************************************** * Installing *source* package 'RODBC' ... checking for gcc... gcc -std=gnu99 checking for C compiler default output file name... a.out checking whether the C compiler works... yes checking whether we are cross compiling... no

I've noticed quite a few messages relating to large data sets bedeviling R users, and having just had to program my way through one that actually caused a "Bus error" when I tried to read it in, I'd like to ask two questions. 1) Are there any facilities for aggregation of data in R? ( I admit that this will not do much for the large data set problem immediately) 2) Is there any

Hello, I want to try to connect R to PostgreSQL. I have found that there are three ways: DBI or RODBC or RPostgreSQL. I tried around with DBI and RODBC but didn't get it running. In both cases I'm not clear about how to set the driver/data source. I get this error: x > channel <- odbcConnect("rtest", uid="oliver") x Warning messages: x 1: In

I have a local installation of MySQL on my computer. I enter the following to access MySQL from the command line: /Applications/MAMP/Library/bin/mysql -h localhost -u root -p I am then prompted for a password, and I use: root This connects me to MySQL in the command line. I now want to access MySQL databases in R. I enter the following: mysql <- dbDriver("MySQL") conn <-

Hello Everyone, The documentation suggests using unixodbc for asterisk realtime. Is there any way we can just use native database clients such as libmysqlclient from MySQL? The native clients tend to be more up-to-date. Thanks in Advance, Nick.

I usually work with R on a windows querying data through RODBC from a postgresql db on a freebsd machine on my offcie lan. Now I have the chance to use R also on a linux gentoo client box and to connect to the same db. I know that I can install the unixodbc stuff and stick to RODBC, BUT my question is: Is there any more 'linuxish' way of querying a postgresql server from a client?

Dear users, I can access an database oracle database using sql developer. This was done by importing an xml file that contains the login details - username, password and specifies that it uses the KERBEROS_AUTHENTICATION. I'm trying to connect R - so that it can access this database - do sql queries and convert the resulting tables into dataframes. I am a novice in SQL and database access

I'm currently working on embedding R into the Apache2 webserver (with some positive results...), but I'm struggling to identify the best way to expose the apache data and functions to R. A couple of thoughts: In light of the recent discussion on "S3/S4 classes performance comparson", I'm leaning toward implementing the interface with S3 style classes. I appreciate

Hello: Using Redhat 7.3 and > version platform i686-pc-linux-gnu arch i686 os linux-gnu system i686, linux-gnu status major 1 minor 6.1 year 2002 month 11 day 01 language R I am trying to install the RODBC package.