Duncan Murdoch wrote:
On 6/27/2006 8:51 AM, Stephane Cruveiller wrote:
Dear R users,
I would like to query a MySQL database through R. I have installed
the latest required packages (RMySQL and DBI) in R (v2.3.1). A MySQL
server (v5.0.22) is running on my local machine but I can't
initialize MYSQL
driver:
------------------------------------------------------------------------------------
> library("RMySQL")
Loading required package: DBI
> MySQL(max.con = 10, fetch.default.rec = 500, force.reload = F)
Error in new("MySQLDriver", Id = drvId) : unused argument(s) (Id ...)
-------------------------------------------------------------------------------------
Could somebody tell me what I have missed?
I have never used RMySQL, but from the error message, this looks like
an incompatibility between it and DBI, presumably because one is newer
than the other.
I have always found it easier to use RODBC. Because it uses the more
general ODBC interface, it may be slower than a package that is tuned
to a particular database, but it works, which is a substantial advantage.
thanks for the hint... I will give it a try very soon.
Duncan Murdoch
Stephane.
______________________________________________
[email protected] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
