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

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