|OSQL(FreeTDS)||FreeTDS (freetds reference manual)||OSQL(FreeTDS)|
osqlis 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
EXAMPLE¶If you have an odbc.ini with a section like this:
[myDSN ] servername = myserver TDS_Version = 5.0
You would invoke
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
osql cannot intuit your
odbc.ini directory, you can force the issue with the
-I option. However, you're then 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.
osqlfirst appeared in FreeTDS 0.65.
osqlutility was written by James K. Lowden.
|April 26, 2012||FreeTDS 1.00.104|