1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
|
." Text automatically generated by txt2man-1.4.7
.TH FreeTDS "February 28, 2008" "0.82RC2" "FreeTDS Utilities"
.SH NAME
\fBosql \fP- utility to test FreeTDS connections and queries
\fB
.SH SYNOPSIS
.nf
.fam C
.TP
.B
\fBosql\fP
-S \fIdsn\fP -U \fIusername\fP -P \fIpassword\fP [-I \fIini_dir\fP]
.fam T
.fi
.SH DESCRIPTION
\fBosql\fP 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.
.PP
\fBosql\fP works only with the isql that comes with unixODBC.
.SH OPTIONS
.TP
.B
-S \fIdsn\fP
the Data Source Name to which to connect, as known
to odbc.ini.
.TP
.B
-U \fIusername\fP
database login name.
.TP
.B
-P \fIpassword\fP
database \fIpassword\fP.
.TP
.B
-I \fIini_dir\fP
override odbc.ini file location.
.SH EXAMPLE
If you have an odbc.ini with a section like this:
.PP
.nf
.fam C
[myDSN]
servername = myserver
TDS_Version = 5.0
.fam T
.fi
You would invoke \fBosql\fP as:
.PP
.nf
.fam C
osql -S myDSN [\.\.\.]
.fam T
.fi
.SH NOTES
If you can connect with "\fBosql\fP -S servername -U user -P passwd", your
FreeTDS ODBC installation is working.
.PP
\fBosql\fP 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.
.PP
If \fBosql\fP cannot intuit your odbc.ini directory, you can force the issue with
the -I option. However, you're instructing \fBosql\fP 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.
.PP
If you have suggestions for ways to make \fBosql\fP more useful as a diagnostic tool,
please post them to the FreeTDS mailing list.
.SH HISTORY
\fBosql\fP first appeared in FreeTDS 0.65.
.SH AUTHORS
The \fBosql\fP utility was written by James K. Lowden
|
