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
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
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
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
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
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
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/
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 ? :(
>
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
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
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
11 matches
Mail list logo