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)

Suggestions?

          -s

        [[alternative HTML version deleted]]

______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

Reply via email to