Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help 
UNTITLED()			     LOCAL			    UNTITLED()

NAME
       tsql -- utility to test FreeTDS connections and queries

SYNOPSIS
       tsql  {-S  servername  [-I interface]  |	 -H  hostname  [-L] [-p	port]}
	    [-D	dbname]	[-U username] [-P password] [-o	options]
       tsql -C

DESCRIPTION
       tsql is a FreeTDS diagnostic tool. It uses the TDS protocol to  connect
       to  a  Sybase or	Microsoft SQL Server, and lets the user	issue queries.
       tsql does not use the FreeTDS client libraries. Instead,	it  uses  only
       the lowest level	library, libtds, to test the protocol implementation.

       tsql  can  be  run in two ways, one which uses the freetds.conf and one
       which connects directly using the server's hostname and port.   The  -H
       and  -p parameters are provided to let the user verify a	server is lis-
       tening on the named host	and port. These	parameters override  any  con-
       figuration  files  and  environment variables.  The -S parameter	can be
       used to test the	local configuration. FreeTDS will use freetds.conf (or
       equivalent) and environment variables in	the normal  way	 to  determine
       the server's IP address and port. You can use -I	to specify a filename,
       overriding FreeTDS's configuration file search algorithm.

OPTIONS
       -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 lo-
	       gin is attempted	for TDS	7+ connections.

       -P password
	       database	password.

       -L      list Microsoft server instances (with -H).

       -C      print some of the compile-time configuration parameters.

       -o options
	       apply the options specified to every command.

	       -f      No footer [result count]

	       -h      No header [titles]

	       -t      Print time

	       -v      Print version

	       -q      Quiet

       -a appname
	       application name.

       -t colterm
	       column terminator.

       -r rowterm
	       row terminator.

       -r rowterm
	       row terminator.

       -J charset
	       character set.

       -v      verbose mode.

NOTES
       If you can connect with `tsql -S	servername', your  basic  FreeTDS  in-
       stallation is working.

       Typing `exit', `quit', or `bye' (or ^D) exits tsql.

       Typing `version'	displays the TDS protocol version.

       Command	batches	 may be	separated with `go' or `GO'.  If `GO' the ver-
       sion string is reported before executing	the batch.

       After prompting for the password	(if not	provided with -P),  tsql  will
       attempt to connect to the remote	server.	 tsql displays a counter indi-
       cating  the  number  of	seconds	elapsed	during the connection attempt.
       Typically, tsql immediately responds with a `1>'	prompt.	If you see the
       counter (1, 2, 3, ...), most likely tsql	is unable to  connect  to  the
       indicated server.

       tsql   is   not	a  replacement	for  a	complete  isql	such  as  sqsh
       (www.sqsh.org).	If you have suggestions	for ways  to  make  tsql  more
       useful  as  a  diagnostic tool, please post them	to the FreeTDS mailing
       list for	consideration.

HISTORY
       tsql first appeared in FreeTDS 0.60.

AUTHORS
       The tsql	utility	was written by Brian Bruns.

BUGS
       Several,	to be sure, now	that it's documented. :)

FreeTDS	dev.1.4.434		March 25, 2015			 TSQL(FreeTDS)

Want to link to this manual page? Use this URL:
<https://man.freebsd.org/cgi/man.cgi?query=tsql&sektion=1&manpath=FreeBSD+Ports+14.3.quarterly>

home | help