使用 Python 连接到 Microsoft SQL 服务器 [英] Connecting to Microsoft SQL server using Python

问题描述

我正在尝试通过 python 连接到 SQL，以便在 Microsoft SQL 服务器上的某些 SQL 数据库上运行一些查询.从我在网上和这个论坛上的研究来看，最有前途的库似乎是 pyodbc.所以我做了以下代码

I am trying to connect to SQL through python to run some queries on some SQL databases on Microsoft SQL server. From my research online and on this forum the most promising library seems to be pyodbc. So I have made the following code

import pyodbc
conn = pyodbc.connect(init_string="driver={SQLOLEDB}; server=+ServerName+; 
database=+MSQLDatabase+; trusted_connection=true")
cursor = conn.cursor()

并得到以下错误

Traceback (most recent call last):
  File "C:\Users...\scrap.py", line 3, in <module>
    conn = pyodbc.connect(init_string="driver={SQLOLEDB}; server=+ServerName+; database=+MSQLDatabase+; trusted_connection=true")
pyodbc.Error: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')

我查看了以下帖子并尝试将我的驱动程序更改为 {sql server} 并且之前在 SAS 中使用 ODBC 链接进行连接，这部分是我上面的代码所基于的，所以不要认为我需要安装其他任何东西.

I have looked at the folowing posts and tried changing my driver to {sql server} and have connected using ODBC links before in SAS, which is partially what my above code is based on, so don't think I need to install anything else.

pyodbc.Error: ('IM002', '[IM002] [unixODBC][驱动程序管理器]未找到数据源名称，并且未指定默认驱动程序 (0) (SQLDriverConnect)')

Pyodbc - "数据源名称未找到，且未指定默认驱动程序

谢谢

推荐答案

我就是这样做的...

import pyodbc 
cnxn = pyodbc.connect("Driver={SQL Server Native Client 11.0};"
                      "Server=server_name;"
                      "Database=db_name;"
                      "Trusted_Connection=yes;")


cursor = cnxn.cursor()
cursor.execute('SELECT * FROM Table')

for row in cursor:
    print('row = %r' % (row,))

相关资源:

• https://github.com/mkleehammer/pyodbc/wiki/Connecting-to-SQL-Server-from-Windows

http://blogs.msdn.com/b/cdndevs/archive/2015/03/11/python-and-data-sql-server-as-a-data-source-for-python-applications.aspx

这篇关于使用 Python 连接到 Microsoft SQL 服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！