Displaying 1 result from an estimated 1 matches for "sqlfreeconnect".
2006 Sep 19
1
RODBC Connections closed automatically in background
...;- someDatabaseOperation(db)
data2 <- someLongCalculation(data)
anotherDatabaseOperation(db, data2) # This often fails b/c the db is no longer open.
odbcClose(db)
}
I see some output:
Warning: closing unused RODBC handle 9
Warning: [RODBC] Error SQLDisconnect
Warning: [RODBC] Error SQLFreeconnect
Warning: [RODBC] Error in SQLFreeEnv
Error in odbcGetErrMsg(channel) : first argument is not an open RODBC channel
I suspect that during the call to someLongCalculation(), R
considers the database connection as "unused", and therefore,
closes the connection, which prevents me from us...