search for: dblistconnections

Displaying 6 results from an estimated 6 matches for "dblistconnections".

2006 Mar 06
3
Disconnect all MySQL connections
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
2009 May 16
1
Fwd: Cannot allocate a new database connection error
...* sub_group_where_condition <- fetch(dbSendQuery(myDbConnect(dbName,hostName), paste(c("SELECT where_clause FROM sub_grp where num=",sub_group_num_data[sub_group_num_loopcounter,1]),collapse="")), n = -1) * } dbDisconnect(con) dbListConnections(MySQL()) l<-list() } Where should i close the DB connection or use one single connection throughout the prograam. -- Thanks Moumita -- Thanks Moumita [[alternative HTML version deleted]]
2007 Mar 20
1
RMySQL load error
...b64/R/lib -lR ** R ** inst ** save image Loading required package: DBI [1] "dbObjectId" [1] "format" [1] "show" [1] "print" [1] "MySQLObject" [1] "MySQLDriver" [1] "dbUnloadDriver" [1] "dbGetInfo" [1] "dbListConnections" [1] "summary" [1] "MySQLConnection" [1] "dbConnect" [1] "dbConnect" [1] "dbConnect" [1] "dbDisconnect" [1] "dbSendQuery" [1] "dbGetQuery" [1] "dbGetException" [1] "dbGetInfo" [1] &qu...
2003 Nov 11
0
Installing and Loading RMySQL on OS X 2.8
...rs ** libs make: `RMySQL.so' is up to date. ** R ** inst ** save image [1] TRUE [1] "dbObjectId" [1] "format" [1] "show" [1] "print" [1] "MySQLObject" [1] "MySQLDriver" [1] "dbUnloadDriver" [1] "dbGetInfo" [1] "dbListConnections" [1] "summary" [1] "MySQLConnection" [1] "dbConnect" [1] "dbConnect" [1] "dbConnect" [1] "dbDisconnect" [1] "dbSendQuery" [1] "dbGetQuery" [1] "dbGetException" [1] "dbGetInfo" [1] "dbListRe...
2005 Mar 09
1
RMySQL installed but not availalable
...age > Loading required package: DBI > [1] "dbObjectId" > [1] "format" > [1] "show" > [1] "print" > [1] "MySQLObject" > [1] "MySQLDriver" > [1] "dbUnloadDriver" > [1] "dbGetInfo" > [1] "dbListConnections" > [1] "summary" > [1] "MySQLConnection" > [1] "dbConnect" > [1] "dbConnect" > [1] "dbConnect" > [1] "dbDisconnect" > [1] "dbSendQuery" > [1] "dbGetQuery" > [1] "dbGetException"...
2002 Oct 16
5
Database newbee problem...
Hi all, This is a potentially very stupid question about MySQL <-> R interaction, but I have not been able to solve it. I'm just trying to connect R to my MySQL databse, and gets this: > library(RMySQL) Loading required package: methods > m <- dbDriver("MySQL") > con <- dbConnect(m,group="testdb") Process R segmentation fault at Wed Oct 16 07:04:30