1FreeTDS(May 14, 2011)                                    FreeTDS(May 14, 2011)
2
3
4

NAME

6       osql - utility to test FreeTDS connections and queries
7

SYNOPSIS

9       osql   -S dsn -U username -P password [-I ini_dir]
10

DESCRIPTION

12       osql  is  a diagnostic tool provided as part of FreeTDS. It is a Bourne
13       shell script that checks and reports on your  configuration  files.  If
14       everything checks out OK, it invokes isql.
15
16       osql works only with the isql that comes with unixODBC.
17

OPTIONS

19       -S dsn the Data Source Name to which to connect, as known to odbc.ini.
20
21       -U username
22              database login name.
23
24       -P password
25              database password.
26
27       -I ini_dir
28              override odbc.ini file location.
29

EXAMPLE

31       If you have an odbc.ini with a section like this:
32
33               [myDSN]
34                       servername = myserver
35                       TDS_Version = 5.0
36
37       You would invoke osql as:
38
39               osql -S myDSN [...]
40
41

NOTES

43       If  you  can  connect with "osql -S servername -U user -P passwd", your
44       FreeTDS ODBC installation is working.
45
46       osql guesses where unixODBC might look for its  odbc.ini  by  examining
47       the  binary.  This  is  not always an effective approach. If it doesn't
48       work, you'll receive a report of candidate strings. Kindly  pass  along
49       the output to help improve the guessing.
50
51       If  osql cannot intuit your odbc.ini directory, you can force the issue
52       with the -I option. However, you're instructing osql what to test,  not
53       where unixODBC will eventually look. Your override is therefore only as
54       good as you are. Look carefully at the error output before overriding.
55
56       If you have suggestions for ways to make osql more useful as a diagnos‐
57       tic tool, please post them to the FreeTDS mailing list.
58

HISTORY

60       osql first appeared in FreeTDS 0.65.
61

AUTHORS

63       The osql utility was written by James K. Lowden
64
65
66
67FreeTDS Utilities                   0.91RC2              FreeTDS(May 14, 2011)
Impressum