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

[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: Access denied for
> user 'user'@'localhost' (using password: NO)
> )
> Fehler in if (dbname == ":memory:") dbDisconnect(connection) else if
> (!dbPreExists && :
> Argument hat Länge 0
>  > detach("package:RMySQL")
>  > sqldf("Select * from mtcars")

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.

+ seth

-- 
Seth Falcon | @sfalcon | http://userprimary.net/user