[R] Disconnect all MySQL connections

mailto-nik at bluemail.ch mailto-nik at bluemail.ch
Mon Mar 6 15:53:54 CET 2006


I work with RMySQL. Now, it works fine.
Thanks a lot for your prompt reply.

Have a nice and successful day
Best regards

>-- Original-Nachricht --
>Date: Mon, 06 Mar 2006 15:35:46 +0100
>From: Uwe Ligges <ligges at statistik.uni-dortmund.de>
>To: mailto-nik at bluemail.ch
>Cc: r-help at stat.math.ethz.ch
>Subject: Re: [R] Disconnect all MySQL connections
>mailto-nik at bluemail.ch wrote:
>> Hi
>> I've got the error "cannot allocate a new connection -- maximum of 16
>> already opened" after I tried to create a new connection to a database.
>> 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

More information about the R-help mailing list