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