I had a very similar problem installing RMySQL with R 2.4.0 on Windows XP.
I beleive that the cause may have been that the RMySQL build used a slightly
older version of the MySQL compiled library functions than was installed on
my machine (I updated both MySQL, DBI, and RMySQL to latest versions prior
to attempting the install). Since RMySQL links to the compiled MySQL
library, slight differences could affect the linked references. I do not
know that this is the source of the problem, but it was one obvious point of
fraility.
The solution, suggested by Prof. Brian Ripley on the r-sig-db list, was to
rebuild the RMySQL library from source prior to doing the install. After
completing the recompilation of the RMySQL package, the install worked as it
should. I believe that the binaries for RMySQL may have been updated since
I had those problems, so you might also want to make sure that you have the
latest version of all the packages.
Date: Sat, 04 Nov 2006 23:53:11 -0600
From: "Joe W. Byers" <[EMAIL PROTECTED]>
Subject: Re: [R] Install RMySQL with R 2.4.0
To: r-help@stat.math.ethz.ch
Message-ID: <[EMAIL PROTECTED]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
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
>
> ______________________________________________
> 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.
>
______________________________________________
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.
