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. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
