osql (1) - Linux Man Pages
osql: utility to test FreeTDS connections and queries
osql - 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.
- -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.
EXAMPLEIf you have an odbc.ini with a section like this:
Bq myDSN servername = myserver TDS_Version = 5.0
You would invoke as:
NOTESIf 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.
HISTORYfirst appeared in FreeTDS 0.65.
AUTHORSThe utility was written by An James K. Lowden Ns .