utility to test FreeTDS connections and queries
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.
works only with the isql that comes with
- the Data Source Name to which to connect, as known to
- database login name.
- database password.
- override odbc.ini file location.
If you have an odbc.ini
with a section like
servername = myserver
TDS_Version = 5.0
You would invoke
osql -S myDSN
If you can connect with ‘
osql -S servername -U user -P
’,your FreeTDS ODBC installation is working.
guesses where unixODBC might look for
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
cannot intuit your
directory, you can force the issue
option. However, you're then
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
more useful as a diagnostic tool, please post them to the FreeTDS mailing
first appeared in FreeTDS 0.65.
utility was written by
James K. Lowden