title: R DBI ODBC error: nanodbc/nanodbc.cpp:3110: 07009: [Microsoft][ODBC Driver 13 for SQL Server]Invalid Descriptor Index
body: <p>I continue to read the <code>DBI/ODBC</code> is faster than <code>RODBC</code>, so I tried as follows:</p>
  
  <pre><code>require(DBI);require(odbc)
  con &lt;- DBI::dbConnect(odbc::odbc(), dsn = 'SQLSERVER1', database = 'AcumaticaDB')
  </code></pre>
  
  <p>I can make a successful connection to the DSN, but the following query:</p>
  
  <pre><code>rs &lt;- dbGetQuery(con, "SELECT * FROM inventoryitem")
  dbFetch(rs)
  </code></pre>
  
  <p>gives me the following error:</p>
  
  <blockquote>
    <p>Error in result_fetch(res@ptr, n, ...) : 
      nanodbc/nanodbc.cpp:3110: 07009: [Microsoft][ODBC Driver 13 for SQL Server]Invalid Descriptor Index </p>
  </blockquote>
  
  <p>What am I doing wrong ?
  Please, no <code>RODBC</code> solutions.
  Thanks!</p>