Re: [R] RMySQL Error

2009-07-23 Thread Cedrick Johnson
Make a copy of the libmySQL.dll and put it in your R_HOME\bin directory and try again.. Just to be on the safe side, I created an env variable called R_HOME and added R_HOME\bin to my path. HTH -c Brock Tibert wrote: Hi Everyone, I am relatively new to R, but I want to try to

[R] RMySQL Error

2009-07-23 Thread Brock Tibert
Hi Everyone, I am relatively new to R, but I want to try to learn how to use it and potentially replace the other commercial packages I have learned to use over the years. That said, I need to get at data in databases, more specifically, MySQL. I installed the RMySQL package without error, but wh

Re: [R] [solved] Re: I can't do it again on an other PC : R+RMySQL ->error loading dll

2007-09-12 Thread Ptit_Bleu
Thanks for the procedure. It sounds easy. I will test it when I have time and see if there are differences (I hope I won't see anything : from a working configuration, if I change to RODBC, I'd like to get another working one). Ptit BLeu. Vladimir Eremeev wrote: > > Hi! > In my case, advantag

Re: [R] [solved] Re: I can't do it again on an other PC : R+RMySQL ->error loading dll

2007-09-12 Thread Vladimir Eremeev
Hi! In my case, advantages of using RODBC are in the fact that it is working, and is getting updated on a regular basis. Nothing more. :) I also had some difficulties to set up the DSN, old Windows NT 4.0 required couple of restarts, and guessing correct 'magic' line to make MS Excel to retrieve

Re: [R] [solved] Re: I can't do it again on an other PC : R+RMySQL ->error loading dll

2007-09-12 Thread Ptit_Bleu
Hi Vladimir, In fact, at the beginning, I tried to install RODBC and the MySQL driver but I did not manage (I think due to the driver and the configuration in the control panel). Then I tried to install RMySQL and DBI on my PC (not the one with the "real" database), and it worked without any prob

Re: [R] [solved] Re: I can't do it again on an other PC : R+RMySQL ->error loading dll

2007-09-11 Thread Peter Dalgaard
Ptit_Bleu wrote: > Hi, > > just to say that I "solved" my problem. I wrote "solved" because all I did > was to uninstall R and the DBI and RMySQL libraries and then install > everything again. > The only change is that I used another RMySQL.zip file found at this address > : > http://www.bioconduct

Re: [R] [solved] Re: I can't do it again on an other PC : R+RMySQL ->error loading dll

2007-09-11 Thread Gustaf Rydevik
On 9/11/07, Peter Dalgaard <[EMAIL PROTECTED]> wrote: > Ptit_Bleu wrote: > > Hi Peter, > > > > I really have no idea about your comment. I was so happy to be able to > > connect to my database ... > > > > In fact I found the address in the following post : > > https://stat.ethz.ch/pipermail/r-help/

Re: [R] [solved] Re: I can't do it again on an other PC : R+RMySQL ->error loading dll

2007-09-11 Thread Peter Dalgaard
Ptit_Bleu wrote: > Hi Peter, > > I really have no idea about your comment. I was so happy to be able to > connect to my database ... > > In fact I found the address in the following post : > https://stat.ethz.ch/pipermail/r-help/2007-August/138142.html > > Do you think I can't use it freely ? :( >

Re: [R] [solved] Re: I can't do it again on an other PC : R+RMySQL ->error loading dll

2007-09-11 Thread Vladimir Eremeev
Do you need precisely RMySQL and DBI? RODBC can successfully replace this. I used RMySQL some time ago, but then, after the next version upgrade it stopped working. Switching to RODBC was almost without pain, since function names were quite similar. I simply replaced dbGetQuery with sqlGetQuery

Re: [R] [solved] Re: I can't do it again on an other PC : R+RMySQL ->error loading dll

2007-09-11 Thread Ptit_Bleu
Hi Peter, I really have no idea about your comment. I was so happy to be able to connect to my database ... In fact I found the address in the following post : https://stat.ethz.ch/pipermail/r-help/2007-August/138142.html Do you think I can't use it freely ? :( Thanks for your comments, Ptit

[R] [solved] Re: I can't do it again on an other PC : R+RMySQL ->error loading dll

2007-09-11 Thread Ptit_Bleu
Hi, just to say that I "solved" my problem. I wrote "solved" because all I did was to uninstall R and the DBI and RMySQL libraries and then install everything again. The only change is that I used another RMySQL.zip file found at this address : http://www.bioconductor.org/packages/2.0/extra/bin/w