Re: [R] Passwords for RODBC package

2003-08-22 Thread Prof Brian Ripley
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

[R] Passwords for RODBC package

2003-08-22 Thread 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 de