# FreeTDS User Guide

## A Guide to Installing, Configuring, and Running FreeTDS

### Brian Bruns

### James K. Lowden

Copyright © 2001, 2002, 2003, 2004, 2005, 2006 Brian Bruns and James K. Lowden

Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.1 or any later version published by the Free Software Foundation; with no Invariant Sections, with no Front-Cover Texts, and with no Back-Cover Texts. A copy of the license is included in the section entitled GNU Free Documentation License.

List of Tables
3-1. Versions of the TDS Protocol, by Product
3-2. `freetds.conf` settings
3-3. Valid bitmask values for `debug flags` entry in `freetds.conf`
3-4. Deprecated `freetds.conf` settings
3-5. Combinations of FreeTDS Clients and Servers (April 2001)
4-1. Connection attributes
5-1. pool.conf settings
10-1. db-lib API Implementation Summary
10-2. ct-lib API Implementation Summary
10-3. ODBC API Implementation Summary
A-1. Services Line

List of Examples
3-1. A `freetds.conf` file example
3-2. Failing to connect with tsql
3-3. Connect with tsql using a servername in `freetds.conf`
3-4. Connect with tsql using a hostname and port number
3-5. Show compile-time settings with tsql
4-1. Sample files for a DSN-less configuration
4-2. Connecting with a DSN-less configuration
4-3. Connecting with a DSN-less configuration that does not use `freetds.conf`
4-4. Sample ODBC-only `odbc.ini` file
4-5. Sample ODBC-combined `odbc.ini` file
4-6. Sample ODBC-combined `freetds.conf` file
4-7. Compile `odbctest` without a driver manager.
5-1. Emulate Little Endian `freetds.conf` setting
5-2. Configuring for GREEK `freetds.conf` setting
5-3. Configuring for UTF-8 `freetds.conf` setting
5-4. Logging in with a domain login
5-5. Turning on Dump File Append mode in `freetds.conf`
5-6. pool.conf
5-7. Unencrypted entry in `freetds.conf`
5-8. Encrypted entry in `freetds.conf`
6-1. The SQSH Makefile
6-2. Building DBD::Sybase
6-3. Connect to a server with DBD::Sybase
6-4. Building DBD::ODBC
6-5. Connect to a server with DBD::ODBC
6-6. PHP and db-lib for "Sybase"
7-1. Finding the server's host
7-2. Finding the server
7-3. Connecting to the server, bypassing `freetds.conf`
7-4. Connecting to the server using `freetds.conf`
A-1. An `interfaces` file example
B-1. "HELLO" in UCS-2 and UTF-8

|  | Next
|  | About this User Guide