R help - Aug 2003 - Passwords for RODBC package

Is there a way to make the RODBC package prompt for a
password on the odbcConnect(db,uid="user1") call?  I'd
prefer not to have to use the pwd= parameter as this
is saved in .RHISTORY and .RDATA.

Is there a convenient way to provide the password as a
variable and have the variable automatically deleted
before .RDATA is saved?

Thanks in advance.

====Bruce Moore

Use odbcDriverConnect.

On Fri, 22 Aug 2003, Bruce Moore wrote:
> Is there a way to make the RODBC package prompt for a
> password on the odbcConnect(db,uid="user1") call?  I'd
> prefer not to have to use the pwd= parameter as this
> is saved in .RHISTORY and .RDATA.
> 
> Is there a convenient way to provide the password as a
> variable and have the variable automatically deleted
> before .RDATA is saved?
-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595