Dan Rie wrote:
> 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.
>
What do you do if you are accessing the Mysql server remotely from the
machine that R is install upon. No MYsql libraries or other files are
stored on either of my computers.
Thank you
>
> 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.
