osql (1) - Linux Man Pages

osql: utility to test FreeTDS connections and queries

NAME

osql - utility to test FreeTDS connections and queries

SYNOPSIS

-S dsn -U username -P password [-I ini_directory ]

DESCRIPTION

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 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:
Bq myDSN
servername = myserver
TDS_Version = 5.0

You would invoke as:

osql -S myDSN [...]

FILES

odbc.ini freetds.conf

NOTES

If you can connect with `osql' -S servername -U user -P passwd Ns , your FreeTDS ODBC installation is working.

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 cannot intuit your odbc.ini directory, you can force the issue with the -I option. However, you're then instructing 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 list.

HISTORY

first appeared in FreeTDS 0.65.

AUTHORS

The utility was written by An James K. Lowden Ns .