pandas with pyodbc - Nan error: [42S22] ERROR: Attribute 'QNAN' not found (31) (SQLExecDirectW)
<p>While running pyodbc execute() with data from pandas DataFrame (x1 is number type)</p>

<pre><code>sql = "select * from t where x1=?"
cursor.execute(sql, df[row,'x1'])
</code></pre>

<p>got strange looking error: </p>

<p><strong>('42S22', "[42S22] ERROR: Attribute 'QNAN' not found (31) (SQLExecDirectW)")</strong></p>

<p>How to read the error message like that?</p>