1FreeTDS(November 27, 2004)                          FreeTDS(November 27, 2004)
2
3
4

NAME

6       tsql - utility to test FreeTDS connections and queries
7

SYNOPSIS

9       tsql   {-S servername [-I inside] | -H hostname -p port}
10              -U username [-P password]
11
12
13       tsql   -C
14

DESCRIPTION

16       tsql  is a diagnostic tool provided as part of FreeTDS. It uses the TDS
17       protocol directly to connect to Sybase or Microsoft  SQL  Servers,  and
18       allows the user to issue queries that test the capabilities of FreeTDS.
19
20       tsql  is  *not*  a  replacement  for  a  complete  isql,  such  as sqsh
21       (www.sqsh.org).  It is designed to rely on  the  lowest  level  FreeTDS
22       library,  tdslib,  as  a  way to isolate potential bugs in the protocol
23       implementation.
24
25       tsql can be run in two ways, one which uses the  freetds.conf  and  one
26       which connects directly using the server's hostname and port.
27
28       When  -S  is  used,  FreeTDS  uses the freetds.conf (or equivalent) and
29       environment variables in the normal way to determine  the  server's  ip
30       address  and  port.  You  can  use -I to specify a filename, overriding
31       FreeTDS's configuration file search algorithm.
32
33       The -H and -p parameters are provided  especially  for  troubleshooting
34       new configurations (or servers). Use of these parameters causes FreeTDS
35       to ignore any freetds.conf and environment variables.
36

OPTIONS

38       -S servername
39              the Database Server to which to connect.
40
41       -I inside a freetds.conf or interfaces file describing servername
42
43       -H hostname
44              the DNS hostname of the server
45
46       -p port
47              the port at which SQL Server is listening
48
49       -U username
50              database login name.
51
52       -P password
53              database password.
54
55
56       -C     prints some of the compile-time configuration parameters.
57

NOTES

59       Typing "exit", "quit", or "bye" (or ^D) exits tsql.
60
61       Typing "version" displays the TDS protocol version.
62
63       Command batches may be separated with "go" or "GO". If "GO",  the  ver‐
64       sion string is reported before executing the batch.
65
66       If  you  can  connect  with  "tsql  -S  servername", your basic FreeTDS
67       installation is working.
68
69       If you have suggestions for ways to make tsql more useful as a diagnos‐
70       tic tool, please recommend them to the FreeTDS mailing list for consid‐
71       eration.
72

HISTORY

74       tsql first appeared in FreeTDS 0.60.
75

AUTHORS

77       The tsql utility was written by Brian Bruns.
78

BUGS

80       Several, to be sure, now that it's documented. :)
81
82
83
84                                    0.63RC1         FreeTDS(November 27, 2004)