|TSQL(FreeTDS)||FreeTDS (freetds reference manual)||TSQL(FreeTDS)|
tsql — utility to
test FreeTDS connections and queries
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
-p parameters are provided to let the user verify a
server is listening on the named host and port. These parameters override
any configuration 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.
- database server to which to connect.
- database to use.
- freetds.conf or interfaces file describing servername.
- DNS hostname of the server.
- port at which SQL Server is listening.
- database login name. If username is not provided, a domain login is attempted for TDS 7+ connections.
- database password.
- list Microsoft server instances (with
- print some of the compile-time configuration parameters.
- apply the options specified to every command.
- application name.
- column terminator.
- row terminator.
- row terminator.
- character set.
- verbose mode.
If you can connect with ‘
servername’,your basic FreeTDS installation is working.
the TDS protocol version.
Command batches may be separated with
GO’ the version string is reported
before executing the batch.
After prompting for the password (if not provided with
tsql will attempt to
connect to the remote server.
tsql displays a
counter indicating the number of seconds elapsed during the connection
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.
tsql first appeared in FreeTDS 0.60.
tsql utility was written by
Several, to be sure, now that it's documented. :)
|March 25, 2015||FreeTDS 1.3.6|