FreeTDS

freetds

FreeTDS is a free implementation of Sybase's DB-Library, CT-Library, and ODBC libraries.

Runs as tsql, freebcp|macOS, Linux, Windows|www.freetds.org

Open form in Otty otty.toml

Command form

ai-draft · 2 tasks · 7 fields

Open an interactive tsql session to a SQL Server or Sybase server, by configured server name or by host and port. The password is not asked for here; tsql prompts for it.

Opens the form; the finished command lands at your prompt, unrun

Run in Otty

otty gui freetds

Connect with tsqlExample values, fixed in this page — nothing here reaches a terminal

Basic

Server name*

string

User name

string

Database

string

TasksEach one presets the form for one job

Connect to a configured server

serveruserdatabase

Connect by host and port

hostportuserdatabase

ParametersOnly these flags are editable in the form

Server name

A server defined in freetds.conf. Use this or Host.
string

-S

Host name

Connect directly by DNS name, bypassing freetds.conf. Use this or Server.
string

-H

Port

integer

-p

User name

string

-U

Database

string

-D

Interfaces / freetds.conf file

path

-I

List server instances

Used with Host.
boolean

-L

SourcesEvery flag above is checked against these

manual

-S servername database server to which to connect. -D dbname database to use. -I interface freetds.conf or interfaces file describing servername. -H hostname DNS hostname of the server. -p port port at which SQL Server is listening. -U username database login name. If username is not provided, a domain login is attempted for TDS 7+ connections. -L lis…

manualtsql(1), FreeTDS 1.5.20

man.archlinux.org

Before it fills your prompt, Otty checks the installed tsql against its version. A form that does not match your version is not offered.