Re: [R] Install RMySQL with R 2.4.0

From: Joe W. Byers <Joe-Byers_at_utulsa.edu>
Date: Sat 04 Nov 2006 - 15:40:58 GMT

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.

Thank you
Joe

Frank McCown wrote:
> I just installed RMySQL 0.5-9 with R 2.4.0 on Windows XP and got the
> following error message when trying to run a script with RMySQL:
>
> Error in library(RMySQL) : 'RMySQL' is not a valid package -- installed
> < 2.0.0?
>
> Any ideas?
>
> Thanks,
> Frank
>
> ______________________________________________
> 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. Received on Sun Nov 05 02:47:05 2006

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Sat 04 Nov 2006 - 18:30:15 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.