ubuntu中安装Sqlserver客户端

1、⾄页⾯下载⽐较新的unixODBC-2.3.

在你所选的⽬录下进⾏解压

tar -zxvf unixODBC-2.3.

cd unixODBC-2.3.7

./configure --prefix=/usr/local/unixODBC-2.3.7 --includedir=/usr/include --libdir=/usr/lib --bindir=/usr/bin --sysconfdir=/etc make

青岛张韶军

比表面积make install

2、安装unixODBC-dev

sudo apt-get install unixODBC-dev

3、安装freetds-dev、tdsodbc

sudo apt-get install freetds-dev tdsodbc

配置freetds

[服务名]

host = sql-server IP

斑蟊port = 1433

tds version = 7.0

4、配置驱动程序odbcinst.ini

声阻抗率[FreeTDS]

护理综述Description = FreeTDS driver

Driver = /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so

桂林旅游高等专科学校学报Setup = /usr/lib/x86_64-linux-gnu/odbc/libtdsS.so

FileUsage = 1

5、配置odbc.init数据库连接认证

[mssql]

Description = sqlserver connection

Driver = FreeTDS

TDS_Version = 4.2

Trace = On

TraceFile = stderr

Server = 127.0.0.1

Port = 1433

User = user

Password = password

Database = dbname

测试⼀下isql mssql user password

本文发布于:2024-09-22 19:44:24，感谢您对本站的认可！

标签：录下数据库配置客户端综述旅游安装护理

留言与评论（共有 0 条评论）