[R] RMySQL

David James dj at research.bell-labs.com
Mon Jul 10 14:44:08 CEST 2000


Hi,

Try using getDatabases() with a connection object.  Being able
to query MySQL about databases may require you to have 
an open connection.  Thus

> m <- MySQL()
> con <- dbConnect(m, user = user, password = passwd, ...)

> getDatabases(con)
$Database
[1] "Network"    "ggobi"      "mysql"     
[4] "test"       "vital_test"



> Date: Mon, 10 Jul 2000 13:43:32 +0200
> From: Axel Vischer <axel.vischer at efot.com>
> X-Accept-Language: en
> MIME-Version: 1.0
> To: r-help at stat.math.ethz.ch
> Subject: [R] RMySQL
> 
> Hi!
> 
> I'm trying to test the RMySQL package (in Devel). The following error
> occured while trying to connet to our MySQL database:
> 
> > m <- MySQL()
> > getDatabases(m)
> Error in newConnection.MySQLManager(dbMgr, ...) :
>         MySQL driver: (could not open MySQL)
> >
> 
> Does anybody know what the problem is? How to proceed?
> 
> Thanks,
> 
> Axel Vischer
> 
> 
> --
> 
> 
------------
David A. James
Statistics Research, Room 2C-253            Phone:  (908) 582-3082       
Bell Labs, Lucent Technologies              Fax:    (908) 582-3340
Murray Hill, NJ 09794-0636

-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._



More information about the R-help mailing list