title: RODBC odbcDriverConnect() Connection Error
body: <p>I'm trying to use </p>
  
  <pre><code>odbcDriverConnect('driver={SQL Server};server=servername\instancename,port;database=testing;username=abc;password=123456') 
  </code></pre>
  
  <p>to connect remote database server (sql server 2008). But I got </p>
  
  <blockquote>
    <p>[RODBC] ERROR: state 08001, code 17, message [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. </p>
  </blockquote>
  
  <p>error. Any idea?</p>
  
  <p>I can use </p>
  
  <pre><code>odbcDriverConnect('driver={SQL Server};server=localhost;database=testing;trusted_connection=true') 
  </code></pre>
  
  <p>to connect my local database server (sql server 2008).</p>