title: Numeric value out of range using R, ODBC and DBI
body: <p>I have a problem that you could help me to solve.
  I had been trying to insert some rows into a table. 
  I show you the table definition:</p>
  
  <pre><code>CREATE TABLE Scc_OrdenSevicioFunerarioPagare(
  [NumeroPagare] [int] NOT NULL,
  [CodigoEstablecimiento] [tinyint] NOT NULL,
  [NumeroOrden] [int] NOT NULL,
  [CodigoClienteAvalista] [int] NOT NULL,
  [ValorRecibido] [money] NOT NULL,
  [ValorPagare] [money] NOT NULL,
  [FechaPago] [date] NOT NULL,
  [CantidadPago] [int] NOT NULL)
  </code></pre>
  
  <p>Using R, I had tried to insert the rows with the next code:</p>
  
  <pre><code>dsnDesarrollo &lt;- "TESTSQL";
  SCC_OrdenServicioFunerarioPagare &lt;- "Scc_OrdenSevicioFunerarioPagare";
  con &lt;- dbConnect(odbc::odbc(), dsnDesarrollo, encoding = 'latin1');
  dbWriteTable(con, SCC_OrdenServicioFunerarioPagare, dfPagareFuente, append = TRUE);
  dbDisconnect(con);
  </code></pre>
  
  <p>My dataframe <strong>dfPagareFuente</strong> only has one row at moment (just for test), the data: </p>
  
  <pre><code>(0 &lt;dbl&gt;, 3 &lt;dbl&gt;, 2214 &lt;dbl&gt;, 56239 &lt;dbl&gt;, 2275 &lt;dbl&gt;, 2600 &lt;dbl&gt;, '2017-01-05' &lt;dttm&gt;, 3 &lt;dbl&gt;)
  </code></pre>
  
  <p>But when I tried to run my R code, I got the error:</p>
  
  <blockquote>
    <p>Error in result_insert_dataframe(rs@ptr, values) : 
      nanodbc/nanodbc.cpp:1587: 22003: [Microsoft][ODBC SQL Server Driver]Valor numérico fuera del intervalo (Numeric value out of range)</p>
  </blockquote>
  
  <p>Anyone can give me a clue about what am I doing wrong or any solution to this?</p>
  
  <p>Always thank you.
  By the way, I'm using the DBI and odbc library for R.</p>