[R] RMySQL

[Wladimir Eremeev]

Dear laurent,

> This is what I did to make the connection :
>  > drv <- dbDriver("MySQL")
>  > con <- dbConnect(drv)

Here's the error.
You should give the database name.
drv <-dbConnect(drv, dbname="dfghdfgsdfgsdfgsdfgsdfgsdfgsdf")
                     ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> Then I should be able to send requests. But when I try this :
>  > dbListTables(con)
> character(0)

Of course.
Tables are stored in the database. You didn't provide its name.
Function dbListTables doesn't know which tables should it list.
  
-- 
Best regards
Wladimir Eremeev                                     mailto:wl at eimb.ru

==========================================================================
Research Scientist                                Leninsky Prospect 33,
Space Monitoring & Ecoinformation Systems Sector, Moscow, Russia, 119071,
Institute of Ecology,                             Phone: (095) 135-9972;
Russian Academy of Sciences                       Fax: (095) 954-5534