What is FreeTDS driver?

FreeTDS is a set of libraries for Unix and Linux that allows your programs to natively talk to Microsoft SQL Server and Sybase databases. Technically speaking, FreeTDS is an open source implementation of the TDS (Tabular Data Stream) protocol used by these databases for their own clients.

How do I find the FreeTDS version?

Choosing protocol version before FreeTDS 1.1

  1. Step 1: Find out which FreeTDS version you are running. You can use the command: `tsql -C`
  2. Step 2: Find out what version of Microsoft SQL Server you are running.
  3. Step 3: Pick the lower TDS Version number out of what matches steps 1 and 2 from the table below.

How do I install FreeTDS on my Mac?


  1. To install freetds, run the following command in macOS terminal (Applications->Utilities->Terminal) sudo port install freetds Copy.
  2. To see what files were installed by freetds, run: port contents freetds Copy.
  3. To later upgrade freetds, run: sudo port selfupdate && sudo port upgrade freetds Copy.

How do I know if I have Freetds installed?

Confirm the installation

  1. FreeTDS can find and read freetds. conf.
  2. servername exists in freetds. conf.
  3. a host property exists for servername.
  4. host can be resolved to a network address.
  5. the server is listening to the port or named instance.
  6. the user can log in to the server.

How do you check if Freetds is installed?

Where is UnixODBC installed?

UnixODBC consists of a lot of libraries, installed in /usr/local/lib, and a few executable files (binaries) installed into /usr/local/bin. These executable files are ODBCConfig, DataManager, and odbcinst.

Where is Freetds conf?

The default location of freetds. conf is determined by the sysconfdir option of configure. If you don’t specify anything, configure’s default sysconfdir is /usr/local/etc.

Where is Freetds installed?

The FreeTDS ODBC driver should be installed in /usr/local/freetds/lib – look for libtdsodbc.so.