R help - Feb 2010 - RODBC connection name

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]]

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.
>