title: Connect Oracle DB through RStudio using RODBC
body: <p>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</p>
  
  <p><code>library("RODBC", lib.loc="~/R/x86_64-pc-linux-gnu-library/3.0")</code></p>
  
  <p>Then I have entered following command:</p>
  
  <p><code>odbcConnect(dsn = "DatabaseName", uid = "UserID", pwd = "Password")</code></p>
  
  <p>I get the following error:</p>
  
  <p><code>[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</code></p>
  
  <p>I have searched but I am not getting to anywhere. Please tell me process or steps to how I can make a connection.</p>
  
  <p>Thank You!</p>