擅长:python、mysql、java
<p>如果其他人发现这个线程正在寻找一个与我在Python2.7中看到的类似错误的解决方案:</p>
<pre><code>Traceback (most recent call last):
File "get_data.py", line 10, in <module>
connection = get_connection(r"XXX\YYY", "DB")
File "get_data.py", line 7, in get_connection
conn = adodbapi.connect(connstring)
File "C:\Python27\lib\site-packages\adodbapi\adodbapi.py", line 116, in connect
raise api.OperationalError(e, message)
adodbapi.apibase.OperationalError: (InterfaceError("Windows COM Error: Dispatch('ADODB.Connection') failed.",), 'Error opening connection to "Data Source=XXX\\YYY; Initial Catalog=DB; Provider=SQLOLEDB.1; Integrated Security=SSPI"')
</code></pre>
<p>在我的例子中,简单的解决方案是从这里安装Python for Windows扩展(pywin32):
<a href="http://sourceforge.net/projects/pywin32/files/pywin32/Build%20219/" rel="nofollow">http://sourceforge.net/projects/pywin32/files/pywin32/Build%20219/</a></p>