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