擅长:python、mysql、java
<p>不要在连接字符串中的<code>Driver</code>关键字后面加空格。</p>
<p>这在Windows上失败。。。</p>
<pre class="lang-python prettyprint-override"><code>conn_str = (
r'DRIVER = {SQL Server};'
r'SERVER=(local)\SQLEXPRESS;'
r'DATABASE=myDb;'
r'Trusted_Connection=yes;'
)
cnxn = pyodbc.connect(conn_str)
</code></pre>
<p>。。。但这是有效的:</p>
<pre class="lang-python prettyprint-override"><code>conn_str = (
r'DRIVER={SQL Server};'
r'SERVER=(local)\SQLEXPRESS;'
r'DATABASE=myDb;'
r'Trusted_Connection=yes;'
)
cnxn = pyodbc.connect(conn_str)
</code></pre>