Python 连接SQLSERVER

最新推荐文章于 2024-01-26 13:55:04 发布

victory0508

最新推荐文章于 2024-01-26 13:55:04 发布

阅读量2.9k

点赞数

CC 4.0 BY-SA版权

分类专栏： python

本文链接：https://blog.youkuaiyun.com/victory0508/article/details/51554032

python 专栏收录该内容

17 篇文章

订阅专栏

本文详细介绍如何在Ubuntu Linux环境下使用Python连接MSSQL数据库，包括安装必要的软件包如freetds-dev、python-dev等，并通过pymssql及pyodbc进行连接配置。特别针对pyodbc安装过程中遇到的依赖问题提供了具体的解决方案。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

如果使用pyodbc，直接看2就可以了，可以略过1

1. Python连接mssql

ubuntu linux上

1.1

sudo apt-get install python

1.2 重启终端

1.3

sudo apt-get --assume-yes update  
sudo apt-get --assume-yes install freetds-dev freetds-bin  
sudo apt-get --assume-yes install python-dev python-pip  
sudo pip install pymssql

1.4

sudo vi /etc/freetds/freetds.conf

2.安装pyodbc

２.１　为了解决pyodbc.h:52:17: fatal error: sql.h: No such file or directory

sudo yum install unixODBC-devel.x86_64

然后：

sudo pip install pyodbc

２.２　安装MSSQL native client

2.3

编写Python程序：

import pyodbc
conn = pyodbc.connect('DRIVER={SQL Server Native Client 11.0}; SERVER=aaaa; UID=bbbb; PWD=ccc; DATABASE=ddd; Encrypt=yes; TrustServerCertificate=no');

cursor = conn.cursor()
cursor.execute("select count(distinct d) as cnt from ddddd6 where day_id=20160531")
row = cursor.fetchone()
while row:
print str(row[0])
row = cursor.fetchone()

Can't open lib '/opt/microsoft/sqlncli/lib64/libsqlncli-11.0.so.1790.0' : file not found (0) (SQLDriverConnect)"

方案：ldd /opt/microsoft/sqlncli/lib64/libsqlncli-11.0.so.1790.0

    linux-vdso.so.1 => (0x00007fff869fe000)
   libcrypto.so.6 => not found
   libdl.so.2 => /lib64/libdl.so.2 (0x00007f360e269000)
   librt.so.1 => /lib64/librt.so.1 (0x00007f360e061000)
   libssl.so.6 => not found
   libuuid.so.1 => /lib64/libuuid.so.1 (0x00007f360de5b000)
   libodbcinst.so.1 => /lib64/libodbcinst.so.1 (0x00007f360dc44000)
   libkrb5.so.3 => /lib64/libkrb5.so.3 (0x00007f360d964000)
   libgssapi_krb5.so.2 => /lib64/libgssapi_krb5.so.2 (0x00007f360d719000)
   libstdc++.so.6 => /lib64/libstdc++.so.6 (0x00007f360d411000)
   libm.so.6 => /lib64/libm.so.6 (0x00007f360d10f000)
   libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f360cef8000)
   libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f360ccdc000)
   libc.so.6 => /lib64/libc.so.6 (0x00007f360c91a000)
   /lib64/ld-linux-x86-64.so.2 (0x00007f360e7bd000)
   libk5crypto.so.3 => /lib64/libk5crypto.so.3 (0x00007f360c6e4000)
   libcom_err.so.2 => /lib64/libcom_err.so.2 (0x00007f360c4e0000)
   libkrb5support.so.0 => /lib64/libkrb5support.so.0 (0x00007f360c2d2000)
   libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x00007f360c0cd000)
   libresolv.so.2 => /lib64/libresolv.so.2 (0x00007f360beb3000)
   libselinux.so.1 => /lib64/libselinux.so.1 (0x00007f360bc8d000)
   libpcre.so.1 => /lib64/libpcre.so.1 (0x00007f360ba2c000)
   liblzma.so.5 => /lib64/liblzma.so.5 (0x00007f360b807000)