使用 pyodbc 将 SQL Server 连接到 Python 3

问题描述：

import pyodbc

cnxn = pyodbc.connect('DRIVER={SQL Server Native Client 11.0};SERVER=LENOVO-PCN;DATABASE=testing;')

cursor = cnxn.cursor()

cursor.execute("select Sales from Store_Inf")
row = cursor.fetchone() 
if row: 
    print (row)

我尝试使用带有模块 pyodbc 的 python 3 来连接 SQL Server Express.我的代码出错了:

I try using python 3 with module pyodbc to connect SQL Server Express. My codes gave a error:

('08001', '[08001] [Microsoft][SQL Server Native Client 11.0]命名管道提供程序:无法打开与 SQL Server [2] 的连接.(2)(SQLDriverConnect)')

('08001', '[08001] [Microsoft][SQL Server Native Client 11.0]Named Pipes Provider: Could not open a connection to SQL Server [2]. (2) (SQLDriverConnect)')

对此有什么想法吗?

答

这是一个使用 Trusted_Connection=yes 对我有用的示例

Here is an example that worked for me using Trusted_Connection=yes

import pyodbc

conn_str = pyodbc.connect(
    Trusted_Connection='Yes',
    Driver='{ODBC Driver 11 for SQL Server}',
    Server='SERVER_NAME,PORT_NUMBER',
    Database='DATABASE_NAME'
)

connection = pyodbc.connect(conn_str)

请注意端口号以逗号分隔！

Please note that port number is comma separated!

使用 pyodbc 将 SQL Server 连接到 Python 3

相关推荐