Displaying 2 results from an estimated 2 matches for "sqldisconnect".
2006 Sep 19
1
RODBC Connections closed automatically in background
...odbcSetAutoCommit(db, FALSE)
data <- 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 t...
2001 May 14
1
RODBC: closing databases
Dear all,
platform i386-pc-mingw32
arch x86
os Win32
system x86, Win32
status
major 1
minor 2.3
year 2001
month 04
day 26
language R
I wrote the following to import tables in different database formats
(Access, Visual FoxPro, etc.):
getTable <-