[R] RODBC and connection parameters

Yves Gauvreau cyg at sympatico.ca
Mon Feb 12 17:20:22 CET 2001




> -----Message d'origine-----
> De : owner-r-help at stat.math.ethz.ch
> [mailto:owner-r-help at stat.math.ethz.ch]De la part de Frank Gerrit
> Zoellner
> Envoye : Monday, February 12, 2001 9:31 AM
> A : r-help at stat.math.ethz.ch
> Objet : [R] RODBC and connection parameters
>
>
> 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.

No, it's not there at least under NT and I'm sure pwd are **coded** in the
registry somewhere. I think it would be pointless to have secured systems if
anyone can have access to uid and pwd reading some text file. But if you
have proper privilege to the DB you should be able to have a look at uid &
pwd.

I think what you want is more like the following. If you don't supply the
pwd when you make the connection, you will be prompted (under NT) to give
one. Which in turn allows the DBM to take care of security instead of you.

Regards

YG


>
> 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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._



More information about the R-help mailing list