[R] Install RMySQL with R 2.4.0

[Seth Falcon]

"Joe W. Byers" <Joe-Byers at utulsa.edu> writes:

> 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

Try updating DBI, the RMySQL on CRAN has:

Depends:	R (>= 2.3.0), methods, DBI (>= 0.1-11)