title: ERROR [42000] [Microsoft][SQL Native Client][SQL Server]Incorrect syntax near the keyword 'SET'
body: <p>We are using SQL 2005 Express for storage. </p>
  
  <p>I am using ODBCCommand to update some values in my table but getting the error below.  Table has all valid columns. </p>
  
  <pre>
  ERROR [42000] [Microsoft][SQL Native Client][SQL Server] Incorrect syntax near the keyword 'SET'.
  </pre>
  
  <p>So please let me know what issue with it, the query working fine in SQL Browser.</p>
  
  <p>My code:</p>
  
  <pre><code>cmd = new OdbcCommand("UPDATE Transaction_Details SET SubscriptionCancelled=? WHERE SubscriptionID=?", conn);
  cmd.Parameters.Add("@SubscriptionCancelled", OdbcType.VarChar, 255).Value = "Subscription Cancelled on " + DateTime.Now;
  cmd.Parameters.Add("@SubscriptionID", OdbcType.VarChar, 255).Value = sSubscriptionID;
  </code></pre>