Hello,
Thank you for the response, but I do not have the command called handle in
my linux version. Also it isn't clear to me that you could set the name
before you do the connection?
Thanks,
Rob
On Wed, Feb 24, 2010 at 9:10 AM, Gabor Grothendieck <ggrothendi...@gmail.com
> wrote:
> 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 <rfor...@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@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.
> >
>
> ______________________________________________
> 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.
>
[[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.
