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

[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, 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 the data was difficult. The procedure is simplified in
> Win2000/XP.
> 
> I have MySQL ODBC 3.51 Driver installed.
> Then I go to Start -> Control Panel -> Administrative Tools, double-click
> on 'Data sources (ODBC)', click
> 'Add' in the opened window, choose 'MySQL ODBC 3.51 Driver' from the list,
> enter host name, database name, user name and password. Port is 3306 by
> default.
> Then pressing 'Test Data source' shows if everything is set up correctly.
> MySQL also have to be configured to allow connections.
> 
> RODBC also contains the file with the comprehensive instructions
> (R_HOME/Library/RODBC/Readme).
> 
> 
> Ptit_Bleu wrote:
>> 
>> 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.
>>> 
>>> 
>> 
>> 
> 
> 

-- 
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#a12634485
Sent from the R help mailing list archive at Nabble.com.