[R] Install RMySQL with R 2.4.0

[Seth Falcon]

"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?

Also, what versions of DBI and RMySQL are you using?