最後更新: 2024-10-04

freetds 介紹

FreeTDS is a free implementation of the TDS (Tabular Data Stream) protocol
that is used by Sybase and Microsoft for their database products.

Stable Release (1.4.23@2024)

TDS protocol version

7.1        SQL Server 2000
7.2        SQL Server 2005
7.3        SQL Server 2008
7.4        SQL Server 2012,2014,2016

Choosing protocol version since FreeTDS 1.1

freetds 1.1 improved the discovery of the protocol version.
If you are using Microsoft SQL Server is recommended to leave the version to auto (the default).

freetds.conf

[global]
tds version = auto

[myserver]
host = ntbox.mydomain.com
port = 1433

[myserver2]
host = unixbox.mydomain.com
port = 4000
tds version = 5.0

[myserver3]
host = instancebox.mydomain.com
instance = foo

Other Settings

• client charset
• encryption  off/request/require    # request (if tds version > 7.1 otherwise off)

locales.conf

Its only real purpose now is to control the format of date strings.