title: Error while inserting row into SQL Server with identity
body: <p>Let us consider the following connection string which connects to SQL Server using the ODBC  driver:</p>
  
  <pre><code>Driver={SQL Server Native Client 10.0};Server=xxx.xx.xx.xx,xxxx;Database=mydata;Uid=xx;Pwd=xxxxxx;
  </code></pre>
  
  <ul>
  <li>Database type: SQL Server</li>
  <li>Driver: SQL Server - ODBC native client 10.0</li>
  <li>Provider type: <code>System.Data.Odbc</code></li>
  </ul>
  
  <p>I am executing this command:</p>
  
  <pre><code>SET IDENTITY_INSERT db1.table ON;
  
  INSERT INTO db1.table 
     SELECT * FROM db.table
  
  SET IDENTITY_INSERT db1.table OFF;
  </code></pre>
  
  <p>I am getting errors:</p>
  
  <blockquote>
    <p>*ERROR [23000] [Microsoft][SQL Server Native Client 10.0][SQL Server]An
    explicit value for the identity column in table 'db1.table' can only
    be specified when a column list is used and IDENTITY_INSERT is ON.*</p>
  </blockquote>
  
  <p>What I have to do now in order to solve the issue?</p>
  
  <p>Waiting for your responses..</p>