Message-ID: <17576.030424@eimb.ru>
Date: 2003-04-24T09:49:31Z
From: Vladimir Eremeev
Subject: RMySQL
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