[R] RODBC and connection parameters

[Michael Lapsley]

AFAIR this is RDBMS (or rather the RDBMS ODBC driver implementation) dependant.
Oracle, for example, does allow the auth in the .ini.

As Yves implies this approach makes more sense in a *nix than
MS environment security-wise.

Michael

On Mon, Feb 12, 2001 at 03:31:22PM +0100, Frank Gerrit Zoellner wrote:
> Hi!
>    
> I'm using the RODBC packages for connecting R and a mysql database.
> To do this, i use the function odbcConnect(dsn,uid,pwd).
> Is it possible to read the connection paramters from the odbc.ini file within R?
> +Especially I'm interested in uid/pwd parameters because of security reasons.   
> 
> Thanks
> --
> Frank Gerrit Zoellner
> 
> 
> -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
> r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
> Send "info", "help", or "[un]subscribe"
> (in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
> _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._