title: Failure to connect to odbc database in R
body: <p>I've been trying to connect my company's DMS to R using the <code>odbcConnect</code> command, but get the following message:</p>
  <pre><code>myConn &lt;-odbcConnect(&quot;NZSQL&quot;, uid=&quot;cejacobson&quot;, pwd=&quot;password&quot;)
  Warning messages:
  1: In odbcDriverConnect(&quot;DSN=NZSQL;UID=cejacobson;PWD=password&quot;) :
    [RODBC] ERROR: state IM002, code 0, message [unixODBC][Driver Manager]Data source name not found, and no default driver specified
  2: In odbcDriverConnect(&quot;DSN=NZSQL;UID=cejacobson;PWD=password&quot;) :
    ODBC connection failed
  </code></pre>
  <p>The thing is, I'm positive the Data source name is NZSQL and my uid and password are correct as well. Any insight as to why R may not be finding my data source / driver (the driver is, by the way, specified and working).</p>
  <p>How can I fix this?</p>