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