[R] Passwords for RODBC package

[Bruce Moore]

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