[R] Disconnect all MySQL connections

[Uwe Ligges]

mailto-nik at bluemail.ch wrote:

> Hi
> 
> I've got the error "cannot allocate a new connection -- maximum of 16 connections
> already opened" after I tried to create a new connection to a database. However,
> the reason ist, that i did not disconnect previous connections....
> 
> I don't know the name of this connections. How can I disconnect this "unknown"
> connections and drivers? if I delete all objects, the error still occurs.
> Exists a function which i don't know?
> 
> Thanks a lot for your help.
> Regards
> Nik
> 
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html


Which package are we talking about?

RODBC has: odbcCloseAll()
RMySQL has: dbListConnections() and dbDisconnect()

And others have other methods, just read the corresponding manuals.

Uwe Ligges