Re: [R] [Fwd: Re: question on sqldf syntax]

2010-01-26 Thread Gabor Grothendieck
On Tue, Jan 26, 2010 at 11:55 AM, Seth Falcon wrote: > > That sqldf only works if RMySQL is not attached seems like something worth > investigating and fixing. It should be possible to avoid such conflicts by > proper use of name spaces, but I have not looked into the details of what's > going on.

Re: [R] [Fwd: Re: question on sqldf syntax]

2010-01-26 Thread Seth Falcon
On 1/26/10 2:11 AM, Christian Schulz wrote: Sorry mistake from me. This was another problem in my mind , but with RMySQL. Christian > library(RMySQL) > library(sqldf) > sqldf("Select * from mtcars") Fehler in mysqlNewConnection(drv, ...) : RS-DBI driver: (Failed to connect to database: Error:

[R] [Fwd: Re: question on sqldf syntax]

2010-01-26 Thread Christian Schulz
Sorry mistake from me. This was another problem in my mind , but with RMySQL. Christian > library(RMySQL) > library(sqldf) > sqldf("Select * from mtcars") Fehler in mysqlNewConnection(drv, ...) : RS-DBI driver: (Failed to connect to database: Error: Access denied for user 'user'@'localhost' (u