Hi I work with RMySQL. Now, it works fine. Thanks a lot for your prompt reply.
Have a nice and successful day Best regards Dominik >-- Original-Nachricht -- >Date: Mon, 06 Mar 2006 15:35:46 +0100 >From: Uwe Ligges <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Cc: [email protected] >Subject: Re: [R] Disconnect all MySQL connections > > >[EMAIL PROTECTED] 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 >> >> ______________________________________________ >> [email protected] 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 ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
