[R] Install RMySQL with R 2.4.0

[Joe W. Byers]

Seth Falcon wrote:
> "Joe W. Byers" <Joe-Byers at utulsa.edu> writes:
> 
>> I am having trouble as well with the new version of R 2.4.  I downloaded 
>> the gz file from the cran website,  followed the instructions in the 
>> README.win file and installed RMySQL.  I have mysql installed under 
>> c:\mysql not the program files directory which is the only difference.
>>
>> I get the following error when I attempt to connect to the MySQL Db
>>  > ## open a connection to a MySQL database
>>  > con <- dbConnect(dbDriver("MySQL"),host='localhost',
>> + username='XXXX',dbname = 'StorageSims');
>> Error in function (classes, fdef, mtable)  :
>>          unable to find an inherited method for function "dbConnect", 
>> for signature "MySQLDriver"
>>  >
>>
>> Any help will be appreciated.  I would like to note that there are no 
>> problems with RMySQL on my linux system, only on XP's.
> 
> Just to make sure:
> 
> Before trying the code you posted, you did library("RMySQL"), right?
YES
> 
> Also, what versions of DBI and RMySQL are you using?
RMySQL from http://cran.r-project.org/src/contrib/Descriptions/RMySQL.html
DBI Version 0.1-10 according to the NEWS file in ../R/library
> 
> ______________________________________________
> R-help at stat.math.ethz.ch 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.
>