"Joe W. Byers" <[EMAIL PROTECTED]> writes:
> Seth Falcon wrote:
>> "Joe W. Byers" <[EMAIL PROTECTED]> 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)
______________________________________________
R-help@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.
