[R] RODBC connection name

[Gabor Grothendieck]

If you are using Linux just grep the output of the appropriate ps command.

On Wed, Feb 24, 2010 at 10:34 AM, Rob Forler <rforler at uchicago.edu> wrote:
> 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
> <ggrothendieck at 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 <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.
>> >
>>
>> ______________________________________________
>> 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.
>
>