1.安装UnixODBC
yum install unixODBC unixODBC-devel
odbc_config --version --longodbcversion --cflags --ulen --libs --odbcinstini --odbcini
odbcinst -j
isql --version
![在这里插入图片描述](https://img-blog.csdnimg.cn/059f3a824d354094afdce9f5b21078dc.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA6L-Z5Liq5Lq65piv55yf55qE6I-c,size_19,color_FFFFFF,t_70,g_se,x_16#pic_center)
2.安装ODBC Driver 17 for SQL Server
wget https://packages.microsoft.com/rhel/7/prod/msodbcsql17-17.3.1.1-1.x86_64.rpm
rpm -ivh msodbcsql17-17.3.1.1-1.x86_64.rpm
ll /opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.3.so.1.1
![在这里插入图片描述](https://img-blog.csdnimg.cn/849e788fd2cc43c29aab15202d14bf4d.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA6L-Z5Liq5Lq65piv55yf55qE6I-c,size_12,color_FFFFFF,t_70,g_se,x_16#pic_center)
vim odbcdsn
[MSSQL-KQ]
Driver = ODBC Driver 17 for SQL Server
Description = Attendance SQL Server
Trace = No
Server = 10.128.6.6
Port = 1433
odbcinst -i -s -f ./odbcdsn -l