similar to: RMySQL/DBI

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

Hi, On a Win7 64 bit, I have installed: *R-15.0 and I am running it in 64bits *Rtools215.exe*MySQL 5.5.23 64bits My PATH start with D:\BenSave\Rtools\bin;D:\BenSave\Rtools\MinGW64\bin;D:\BenSave\R\R-2.15.0\bin;D:\BenSave\Rtools\MinGW\bin;D:\BenSave\Rtools\gcc-4.6.3\bin; Note that I place MinGW64\bin has I want the package in 64 bits, so just in case it helps... To install RMySQL 64 bits, I

Dear All, I am having a bit of problem using the DBI and RMySQL package. I have already installed DBI but now I want to connect to MySQL. So how do I do it. The CRAN package repository does not have RMySQL windows binary to install from? Regards, Indrajit Sen Gupta Business Analyst Mu Sigma Business Solutions Pvt Ltd #21/1-1, Nawab Towers Cunningham Road Bangalore 560 052, India Tel: +91 80

Hello, I have trouble installing and loading the RMySQL package on OS X 2.8. The package seems to install from source fine (using R package manager from within the R environment). I have the following error when I try to load the package: loading package: RMySQL Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared library

I have upgraded R on my Linux box from 1.5.1 to 1.6.1 using the binary distributions for redhat 7.x. My machine is runing: Linux 2.4.18-3 Red Hat Linux release 7.3 (Valhalla) After upgrading R, I executed upgrade.packages() During the upgrading of the different packages there was an error on RMySQL. Here is a dump of the upgrading messages:

According David Jame's response to my earlier question, there is a problem with setGeneric.setMethod in R 1.8.0 that affects DBI and RMySQL. Is there a fix for this? David Jame's refers to an 'R-patched version' but I haven't seen anything like this on CRAN. Would going back to an older version of R solve the problem? Thanks, Barnet Wagman "David James wrote:

Hello all, Just uploaded to CRAN updates for RSQLite, RMySQL, and DBI. The primary svn repository for these packages is now hosted by the Gentleman Lab in Seattle and our group is working with David James to help with maintenance. Details on the updates are below. RMySQL_0.5-9.tar.gz * Fixed unclosed textConnections RSQLite_0.4-4.tar.gz * Upgraded to SQLite 3.3.7 * Default when

Hello all, Just uploaded to CRAN updates for RSQLite, RMySQL, and DBI. The primary svn repository for these packages is now hosted by the Gentleman Lab in Seattle and our group is working with David James to help with maintenance. Details on the updates are below. RMySQL_0.5-9.tar.gz * Fixed unclosed textConnections RSQLite_0.4-4.tar.gz * Upgraded to SQLite 3.3.7 * Default when

Dear colleague, I have two data frame which I tried to use dbWriteTable function with append=TRUE to write to the mysql database. The problem is that if I am run my R script directly then it is fine. Both data frame got written into the database. But when I tried to embed the script to be called as system("R --save < whatever.R") in my perl script, I saw very strange things. One

Full_Name: K?re Jonsson Version: 2.10 OS: WinXP Submission from: (NULL) (85.225.178.169) I made a brand new installation of R 2.10 in two machines and got the same problem. Machine 1 is Win XP on metal installation machine 2 is virtual in VMWare running a hacky OS named Tiny XP in which any Microsoft windows XP siftware always successfully is installed. Operation 1. Add package RMySQL from

Hello everybody, i had a big issue with RMySQL, working on an installation of R on multiple nodes via net file-system. The point is that we installed Xampp as suite for mysql, perl, apache and php on every node, and we need to use R scripts with mysql. Xampp doesn't compile anything, it gives you pre-compiled binaries all linked together, you just extract from a tarball. At my first try,

I'm having trouble getting RMySQL to load. I was able to build it and install it (RMySQL_0.5-11.tar.gz). I was also able to build and install mysql-5.0.37. I've read many postings about this but have not found a mention of my particular problem (some closely related). I get the "unable to load shared library, no such file" error, but all the files do exist, RMySQL.so and

Hello, I have a problem.. I'm trying to make R communicate with MySQL, but I always receive an error.. My code is: library(DBI) library(RMySQL) drv <- dbDriver("MySQL") conn<-dbConnect(drv,username="####",password="####",dbname="prova",host="localhost") and I receive this message: Errore in function (classes, fdef, mtable) :

I don't use MySQL but I have seen messages like this before. They often have replies which indicate that you need to follow the instructions more closely. I suggest you search the list for these previous posts as I'm sure there is help there, somewhere! Tom > -----Original Message----- > From: Adriano von Sydow [mailto:pdasilva at xtra.co.nz] > Sent: Thursday, 10 March 2005 5:13

Hi Laurent, The issue is a very simple one to correct --- you only need to re-install RMySQL with the R version you're currently using. The issue is that the internal representation of objects in the methods package changed in 1.8.0, and thus packages that use S4 classes and methods and save their images (like RMySQL) and were installed prior to 1.8.0 need to be re-installed to be used with

I have R 2.10.1 and 2.9.1 installed, and both have RMySQL packages installed. I script I'd developed using an older version (2.8.?, I think) used RMySQL too and an older version of MySQL (5.0.?), and worked fine at that time (about a year and a half ago +/- a month or two). But now, when I run it again, on new data, the script works fine until it is supposed to store its results in my DB.

Folks, I failed to create a connection to the database under MySQL DBMS in the R system via RMySQL's method dbConnection(...). My setup is as follows: Microsoft Windows XP 5.1.2600 MySQL 4.1.9 R 2.0.1 DBI 0.1-8 RMySQL 0.5-5 Both of DBI and RMySQL packages were downloaded from bell lab: http://stat.bell-labs.com/RS-DBI/download/index.html My case in R is as follows: > library(DBI)

Since there doesn't appear to be an RMySQL rpm for SuSE 8.*, does anyone know if the 7.3 version will work with the SuSE 8.2 rpms of R and DBI? The package installs without complaint, but when I try to run con <- dbConnect(dbDriver("MySQL"),dbname="test") I get the error Error in dbConnect(dbDriver("MySQL")) : couldn't find function

Hello everybody, could anybody give me a hint how to to use RMySQL and ROracle libraries at the same time without getting conflict with name spaces? Because it needs to much time, unloading and reloading the libraries is no solution... Example: ----------- snip ----------------- library(ROracle) library(RMySQL) mysql <- MySQL() con <- dbConnect(mysql, user=MySQL.name, password=MySQL.pwd,

Hi, I had my R to MySQL 5.0 connection working fine under 2.5.1 on Windows XP. My MySQL installation is local, not on a server and I could connect with: con <- dbConnect(MySQL(), dbname = "mydatabase", user="root", password="XX") I have updated to R 2.8.1 (RMySQL 0.7-2) but that same line of code yields: Error in mysqlNewConnection(drv, ...) : RS-DBI driver: