
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]]

