擅长:python、mysql、java
<p>另请补充布莱恩·埃尔格尔的回答:我刚刚遇到了这个问题。<strong>结果只是列名有误。</strong></p>
<p>当我故意使用两个错误的列名时,会出现以下错误:</p>
<pre><code>Traceback (most recent call last):
File "C:\...\some_code.py", line 74, in <module>
table_headers, table_data = fetch_relations()
File "C:\...\some_code.py", line 27, in fetch_relations
cur.execute(sql);
File "C:\Python34\lib\site-packages\pypyodbc.py", line 1605, in execute
self.execdirect(query_string)
File "C:\Python34\lib\site-packages\pypyodbc.py", line 1631, in execdirect
check_success(self, ret)
File "C:\Python34\lib\site-packages\pypyodbc.py", line 986, in check_success
ctrl_err(SQL_HANDLE_STMT, ODBC_obj.stmt_h, ret, ODBC_obj.ansi)
File "C:\Python34\lib\site-packages\pypyodbc.py", line 966, in ctrl_err
raise DatabaseError(state,err_text)
pypyodbc.DatabaseError: ('07002', '[07002] [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.')
</code></pre>
<p>注意,在最后一行,<code>Expected 2.</code>与有问题的列的数量对齐。对我来说,当列名正确时,问题就消失了。在</p>