Re: [R] RMySQL...Can't initialize driver???

2006-06-28 Thread Rainer M Krug
Stephane Cruveiller wrote: Rainer M Krug wrote: I followed your instruction. Here is my .my.cnf: --- [client] user=steff password=XX database=justforfun

Re: [R] RMySQL...Can't initialize driver??? Solved!!!

2006-06-28 Thread Stephane Cruveiller
Hi, I have finally made it working. I do not if that was the problem but the libraries (DBI and RMySQL) were installed in a non-standard location (of course specified in a .Renviron file). Reinstalling both of them at R root did the trick... thanks to you all for your help... Stephane.

[R] RMySQL...Can't initialize driver???

2006-06-27 Thread Stephane CRUVEILLER
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:

[R] RMySQL...Can't initialize driver???

2006-06-27 Thread Stephane Cruveiller
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:

Re: [R] RMySQL...Can't initialize driver???

2006-06-27 Thread Stephane Cruveiller
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

Re: [R] RMySQL...Can't initialize driver???

2006-06-27 Thread Duncan Murdoch
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:

Re: [R] RMySQL...Can't initialize driver???

2006-06-27 Thread Rainer M Krug
Stephane Cruveiller wrote: 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

Re: [R] RMySQL...Can't initialize driver???

2006-06-27 Thread David James
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:

Re: [R] RMySQL...Can't initialize driver???

2006-06-27 Thread Stephane Cruveiller
Rainer M Krug wrote: Stephane Cruveiller wrote: 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

Re: [R] RMySQL...Can't initialize driver???

2006-06-27 Thread David James
This looks very suspicious. The function mysqlInitDriver is pretty straight forward (see below), but the error you're reporting apparently has something to do with S4 dispatching: mysqlInitDriver function (max.con = 16, fetch.default.rec = 500, force.reload = FALSE) { if