[R] RODBC connection name

[Gabor Grothendieck]

Use the sysinternals handle command to search for the filename
associated with the connection.

> library(RODBC)
> con <- odbcConnectExcel("test.xls")
> system("handle test.xls", intern = TRUE)
[1] ""
[2] "Handle v3.42"
[3] "Copyright (C) 1997-2008 Mark Russinovich"
[4] "Sysinternals - www.sysinternals.com"
[5] ""
[6] "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
> RODBC.
>
> Thank you for your time,
> Rob
>
>        [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at 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.
>