title: pyODBC insert failing silently
body: <p>I'm using python 3.4 (ActiveState) and pyodbc 3.0.7 on a Windows 7 box to connect to a SQL Server 2008 RC2 database running on Window NT 6.1.</p>
  
  <p>The problem I'm having is that the code below fails silently.  No changes are made to the database.</p>
  
  <pre><code>connection = pyodbc.connect("DRIVER={SQL Server};SERVER=(local);DATABASE=Kerb;UID=sa;PWD=password", autocommit=True)
  cursor = connection.cursor()
  
  cursor.execute('''INSERT INTO [My].[Sample] (Case) VALUES (1);''')
  </code></pre>
  
  <p>I've also attempted to force the insert with a commit statement (which, unless I'm mistaken, shouldn't be necessary due to the autocommit=True), this also fails with no output.</p>
  
  <pre><code>cursor.execute('''INSERT INTO [My].[Sample] (Case) VALUES (1);''')
  cursor.commit()
  </code></pre>
  
  <p>So my solution so far has been to add a sleep, which has solved the problem.  But I worry about implementing this solution in production as it doesn't take into account network lag, etc.</p>
  
  <pre><code>cursor.execute('''INSERT INTO [My].[Sample] (Case) VALUES (1);''')
  time.sleep(1)
  </code></pre>
  
  <p>I believe my question may be related to:
  <a href="https://stackoverflow.com/questions/15935933/pyodbc-and-sql-server-2008-and-python-3">pyODBC and SQL Server 2008 and Python 3</a></p>
  
  <p>If anyone has any ideas for further debugging or has documentation regarding this bit of asynchronous behavior I would love to hear it.</p>
  
  <p>Thanks!</p>