FREETDS.CONF(FreeTDS 5) | FreeTDS 5 (freetds reference manual) | FREETDS.CONF(FreeTDS 5) |
freetds.conf
—
configuration file for FreeTDS
The freetds.conf file describes Sybase and Microsoft database servers to the FreeTDS library. It comprises sections headed by a servername, followed by a list of connection properties denoted as name-value pairs. Defaults are defined via a [global] section. This file supersedes the interfaces file that Sybase defines for the same purpose, although the latter is still supported.
A section begins with a servername — the name of the server — in square brackets. The servername is chosen at the client's descretion. (One exception: with Sybase ASA the servername must match the database name to be used.)
Sections contain properties, one per line, in the form
name = value
where name is the connection property to be described. Servernames and properties are not case sensitive. Values are case-preserving i.e., copied literally. Comments begin with either a semicolon (‘;’) or pound sign (‘#’) and continue to end of line. Blank lines are ignored. Whitespace surrounding the ‘=’ is ignored.
--with-tdsver
value (5.0 if unspecified)Do not define both port and instance. One implies the other.
Boolean property values may be denoted as on/off, true/false, or 1/0.
The log's granularity can be controlled with the debug flags property.
Value | Meaning |
0x02 |
severe error |
0x04 |
error |
0x08 |
warning |
0x10 |
network |
0x20 |
information level 1 |
0x40 |
information level 2 |
0x80 |
function trace and info |
0x1000 |
show pid |
0x2000 |
show time |
0x4000 |
show source level info (source file and line) |
0x8000 |
thread id (not implemented). |
The file is normally named /etc/freetds.conf or ${HOME}/.freetds.conf. That name can be overridden with the FREETDSCONF environment variable.
FreeTDS will search conf files for a servername in the following order:
The search stops with the first file containing the servername.
If no conf file is found, FreeTDS searches for an interfaces file in the following order:
$SYBASE
is an environment variable)
If the requested servername is not found in any configuration file, the fallback mechanism is:
FREETDSCONF
TDSDUMP
TDSDUMPCONFIG
TDSHOST
TDSPORT
TDSQUERY
TDSVER
The environment variables TDSVER,
TDSDUMP,
TDSPORT,
TDSQUERY, and
TDSHOST
override values set by a .conf or interfaces
file.
/etc/freetds/freetds.conf, ${HOME}/.freetds.conf
FreeTDS User Guide
May 2, 2017 | FreeTDS 1.3.17 |