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

______________________________________________
R-help@r-project.org 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.

Reply via email to