[R] RODBC connection name
ggrothendieck at gmail.com
Wed Feb 24 16:10:24 CET 2010
Use the sysinternals handle command to search for the filename
associated with the connection.
> con <- odbcConnectExcel("test.xls")
> system("handle test.xls", intern = TRUE)
 "Handle v3.42"
 "Copyright (C) 1997-2008 Mark Russinovich"
 "Sysinternals - www.sysinternals.com"
 "Rgui.exe pid: 7128 188: C:\\tmp2\\test.xls"
On Wed, Feb 24, 2010 at 9:48 AM, Rob Forler <rforler at uchicago.edu> wrote:
> Hello all,
> I've scoured the RODBC.pdf, but there appears to be no way to set the name
> of the RODBC connection. This is useful for the DBA's to know that some
> processes should only run for so long and can be automatically killed. But
> currently the name is just R. so they aren't sure if the connection can be
> automatically killed.
> We are able to set this with our perl ODBC interfaces via a metadata tag
> called appname, but I'm not entirely sure how or if this is available in
> Thank you for your time,
> [[alternative HTML version deleted]]
> R-help at r-project.org mailing list
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
More information about the R-help