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