search for: odbcvalidchannel

What is the recommended way of checking whether an RODBC connection is open? Since odbcValidChannel is not exported from namespace RODBC, I suppose I shouldn't be using it. This is the best I could come up with, but it seems a bit 'dirty' to be using a tryCatch for something like this: odbcOpenp <- function(conn) tryCatch({odbcGetInfo(conn);TRUE},error=function(...)FALSE)...

Dear All, I would like to count or list the names of the existing worksheets within an .xls file. Any hints? Thaks, Gabor -- Pozsgai G?bor www.coleoptera.hu www.photogabor.com

...is works library(RODBC) con<-odbcConnect("mydb") d<-sqlQuery(con,"select * from meso.trees") However this does not. d<-sqlFetch(con,"meso.trees") Error in odbcTableExists(channel, sqtable) : ?meso.trees?: table not found on channel Apparently the test if (!odbcValidChannel(channel)) is returning true. The inclusion of any non alphanumeric character leads a table name to be considered invalid. This also means that the useful sqlSave and sqlUpdate functions cannot be used in the usual way for tables that are not in the public schema. This has come up several times...