Provided by: freetds-bin_0.91-6.1build1_amd64 
NAME
osql - utility to test FreeTDS connections and queries
SYNOPSIS
osql -S dsn -U username -P password [-I ini_dir]
DESCRIPTION
osql is a diagnostic tool provided as part of FreeTDS. It is a Bourne shell script that checks and
reports on your configuration files. If everything checks out OK, it invokes isql.
osql works only with the isql that comes with unixODBC.
OPTIONS
-S dsn the Data Source Name to which to connect, as known to odbc.ini.
-U username
database login name.
-P password
database password.
-I ini_dir
override odbc.ini file location.
EXAMPLE
If you have an odbc.ini with a section like this:
[myDSN]
servername = myserver
TDS_Version = 5.0
You would invoke osql as:
osql -S myDSN [...]
NOTES
If you can connect with "osql -S servername -U user -P passwd", your FreeTDS ODBC installation is
working.
osql guesses where unixODBC might look for its odbc.ini by examining the binary. This is not always an
effective approach. If it doesn't work, you'll receive a report of candidate strings. Kindly pass along
the output to help improve the guessing.
If osql cannot intuit your odbc.ini directory, you can force the issue with the -I option. However,
you're instructing osql what to test, not where unixODBC will eventually look. Your override is therefore
only as good as you are. Look carefully at the error output before overriding.
If you have suggestions for ways to make osql more useful as a diagnostic tool, please post them to the
FreeTDS mailing list.
HISTORY
osql first appeared in FreeTDS 0.65.
AUTHORS
The osql utility was written by James K. Lowden