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

[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 problem. So I keep
working with RMySQL.

You think there are advantages to try again installing RODBC ?

Anyway, for the moment, I think I will continue with RMySQL, just because it
works. But for me it is a good reason (especially because I'm not a
specialist of PCs and I don't have the time to become one. I'm only an
end-user).

Have a nice day,
Ptit Bleu.



Vladimir Eremeev wrote:
> 
> 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 in my script and voilia.
> 
> However, you need to install the MySQL ODBC driver and set up a data
> source in the Windows Control Panel before.
> 
> 
> Ptit_Bleu wrote:
>> 
>> 
>> 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 Bleu.
>> 
>> 
>> Peter Dalgaard wrote:
>>> 
>>> 
>>> Umm, that looks more than a bit unofficial (parent directory read
>>> protected, no hint of an RMySQL package elsewhere on the site).  Are you
>>> sure that this is intended for redistribution? It sounds like it bundles
>>> in some MySQL libraries, which could imply legal issues.
>>> 
>>> 
>> 
>> 
> 
> 

-- 
View this message in context: http://www.nabble.com/I-can%27t-do-it-again-on-an-other-PC-%3A-R%2BRMySQL--%3Eerror-loading-dll-tf4414597.html#a12633728
Sent from the R help mailing list archive at Nabble.com.