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

[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' (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")
    mpg cyl  disp  hp drat    wt  qsec vs am gear carb
1  21.0   6 160.0 110 3.90 2.620 16.46  0  1    4    4
2  21.0   6 160.0 110 3.90 2.875 17.02  0  1    4    4
3  22.8   4 108.0  93 3.85 2.320 18.61  1  1    4    1
4  21.4   6 258.0 110 3.08 3.215 19.44  1  0    3    1
5  18.7   8 360.0 175 3.15 3.440 17.02  0  0    3    2
.....................
-------------- next part --------------
An embedded message was scrubbed...
From: Christian Schulz <chschulz at email.de>
Subject: Re: [R] question on sqldf syntax
Date: Tue, 26 Jan 2010 10:34:54 +0100
Size: 1577
URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20100126/b2738483/attachment.eml>