Man Pages

osql(1) - phpMan osql(1) - phpMan

Command: man perldoc info search(apropos)  


FreeTDS(May 14, 2011)                                    FreeTDS(May 14, 2011)



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  effec-
       tive  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



FreeTDS Utilities                   0.91RC2              FreeTDS(May 14, 2011)