回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我整天都在网上搜索,尝试了很多解决方案,但没有一个有效。我可以手动连接到此服务器,但不能使用Python。我收到以下错误:</p>
<blockquote>
<p>pyodbc.OperationalError: ('08001', '[08001] [Microsoft][ODBC SQL
Server Driver][DBNETLIB]SQL Server does not exist or access denied.
(17) (SQLDriverConnect); [08001] [Microsoft][ODBC SQL Server
Driver][DBNETLIB]ConnectionOpen (Connect()). (5); [08001]
[Microsoft][ODBC SQL Server Driver]Invalid connection string attribute
(0)')</p>
</blockquote>
<p>我尝试了以下方法:</p>
<ul>
<li><p>(A)</p>
<pre><code>cnx = pyodbc.connect(Driver='{SQL Server}',
SERVER=self.DBserver,
DATABASE=xyz,
username=self.DBusername,
password=self.DBpassword,
PORT = 1433)
</code></pre></li>
<li><p>(B)</p>
<pre><code>cnx = pyodbc.connect('''Driver={SQL Server};
SERVER=tcp:<self.DBserver>;
PORT=self.DBPort; DATABASE=xyz;
UID=self.DBusername;
PWD=self.DBpassword''')
</code></pre></li>
<li><p>(C)</p>
<pre><code>cnx = = pyodbc.connect(Driver='{SQL Server}',
SERVER=self.DBserver,
DATABASE=xyz,
UID=self.DBusername,
PWD=self.DBpassword)
</code></pre></li>
</ul>