title: Using RODBC in R to connect to Azure SQL
body: <p>I am using R 3.2.4 and El captain, I wanted to connect to Azure SQL using the RODBC package in R, I did the following to install it</p>
  
  <pre><code>brew install unixodbc
  install.packages("RODBC",type="source")
  </code></pre>
  
  <p>And also</p>
  
  <pre><code>brew install freetds --with-unixodbc 
  </code></pre>
  
  <p>The output of above command:</p>
  
  <pre><code>Warning: unixodbc-2.3.4 already installed
  Warning: freetds-0.95.80 already installed
  </code></pre>
  
  <p>But whenever I try to connect using the following:</p>
  
  <pre><code>library("RODBC")
  
  con = odbcDriverConnect(
    'driver = {SQL Server};
    Server = xxxxxx;
    Database = xxxxx;
    User Id= xxxxx;
    Password= xxxxx;')
  </code></pre>
  
  <p>I get the following Error:</p>
  
  <pre><code>[RODBC] ERROR: state IM007, code 59478176, message [iODBC][Driver Manager]No data source or driver specified, dialog prohibited
  </code></pre>