Connecting to Oracle DB using Windows Authentication / Trusted Connection in R
There are many examples of how to connect to Oracle DB using password authentication (like user id + password) in R. However, I need to figure out how to set up a connection using Windows Authentication / Reliable Connection in R for Oracle DB.
Example
I've seen a similar case for a MySQL database where a connection string is listed containing trusted_connection=true
which, if I understand correctly, indicates Windows Authentication / Reliable Connection.
library(RODBC)
dbhandle <- odbcDriverConnect('driver={SQL Server};server=servername\\\\instancename,port;database=testing;trusted_connection=true')
res <- sqlQuery(dbhandle, 'select * from information_schema.tables')
1) What exactly would it look like for Oracle DB using the information below?
Additional information (possibly helpful):
In the config file, tsnames.ora
I added the following database address which works using MS Access.
DBNAME.XXX.COM = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = DBNAME.XXX.COM)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DBNAME.XXX.COM) ) )
source to share
No one has answered this question yet
See similar questions:
or similar: