Connect Oracle DB through RStudio using RODBC

1.5k views Asked by At

I might be re-asking the question but I am having difficulty creating connection to Oracle DB which is on a remote server. I am new to R and Oracle DB so I do not have much experience. I am using RStudio. I have installed RODBC package successfully. I am using Ubuntu 14.04 Operating System. Firstly I use library RODBC

library("RODBC", lib.loc="~/R/x86_64-pc-linux-gnu-library/3.0")

Then I have entered following command:

odbcConnect(dsn = "DatabaseName", uid = "UserID", pwd = "Password")

I get the following error:

[1] -1 Warning messages: 1: In RODBC::odbcDriverConnect("DSN=DatabaseName;UID=UserID;PWD=Password") : [RODBC] ERROR: state IM002, code 0, message [unixODBC][Driver Manager]Data source name not found, and no default driver specified 2: In RODBC::odbcDriverConnect("DSN=DatabaseName;UID=UserID;PWD=Password") : ODBC connection failed

I have searched but I am not getting to anywhere. Please tell me process or steps to how I can make a connection.

Thank You!

0

There are 0 answers