[R] Install RMySQL with R 2.4.0
Seth Falcon
sfalcon at fhcrc.org
Sun Nov 5 19:12:07 CET 2006
"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)
More information about the R-help
mailing list