Dear users,
I can access an database oracle database using sql developer. This was done by
importing an xml file that contains the login details - username, password and
specifies that it uses the KERBEROS_AUTHENTICATION.
I'm trying to connect R - so that it can access this database - do sql queries
and convert the resulting tables into dataframes.
I am a novice in SQL and database access - but a friend provided me with the
following approach:
library(DBI)
library(RMySQL)
drvr<-dbDriver("MySQL") #Or another driver, say from the RODBC package?
acon<-dbConnect(drvr, user="ENTER_USERID", dbname="ENTER_NAME",
host="ENTER_HOST",
port=1521,password=NULL) #password maybe non-null?
cmds<-dbSendQuery(acon,statement="YOUR SQL QUERY HERE")
yourdata<-fetch(cmds, n=-1) #Collects all rows and columns of data requested
query.
I have provided this info changing the relevant info in the dbConnect command
and provided the password. However this doesn't work. I suspect because in this
command there is not specification of the encryption of the password (i.e.,
KERBEROS_AUTHENTICATION)
When I look at the details of the connection in SQL developer - what is
specified is the follow:
connection name, username, password (that I cannot see), hostname, port and the
SID.
Note that although the password here cannot be seen -
I believe it is computed by the longer password displaced the the xml file I
use to set up the connection with sql developer using the
KERBEROS_AUTHENTICATION.
Any ideas on how to proceed.
Please help.
Thank you.
Raff.
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
