安装相关系统包 （ in rocky linux)

sudo yum install epel-release
sudo yum install freetds freetds-devel unixODBC  python3-pyodbc

# ubuntu
sudo apt-get install freetds-bin freetds-common tdsodbc odbcinst unixodbc unixodbc-dev

配置FREETDS

#sudo nano /etc/freetds.conf

[global]
  
[vmsap]
         host =192.168.4.213
         port = 1444
         tds version = 7.0
        # tds 版本根据对应的 sqlserver 版本选择，但需要测试 

测试 freetds

 tsql -S vmsap -U sa -P c123456 -p 1444 
# TDSVER=7.0 tsql -S vmsap -U sa -P c123456 -p 1444

# /etc/odbcinst.ini
[FreeTDS]  
Description=FreeTDS ODBC driver for SQL Server  
Driver=/usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so  
FileUsage=1

配置 odbc

#sudo  nano /etc/odbc.ini

[vmsap]
Driver = FreeTDS
Server = 192.168.4.213
Port = 1444
TDS_Version = 7.0

测试 odbc

isql -v vmsap sa c123456

测试代码 pyodbc

# -*- coding: utf-8 -*-
import pyodbc
import os

# 连接字符串
conn_str = (
    "DRIVER={FreeTDS};"
    "SERVER=192.168.4.213,1444;"
    "UID=sa;"
    "PWD=c123456;"
    "DATABASE=master;"    
    "TDS_Version=7.0;"
)

# 连接SQL Server
conn = pyodbc.connect(conn_str)
print("连接成功!")

# 执行SQL查询
cursor = conn.cursor()
cursor.execute("SELECT @@VERSION")
row = cursor.fetchone()
print("SQL Server版本:", row[0])

# 关闭连接
conn.close()
print("连接已关闭")