← Back to branch summary

~ubuntu-branches/debian/lenny/freetds/lenny

« back to all changes in this revision

Viewing changes to doc/doc/freetds-0.82/userguide/odbcombo.htm

  • Committer: Bazaar Package Importer
  • Author(s): Steve Langasek
  • Date: 2008-08-02 11:49:53 UTC
  • mfrom: (2.1.10 intrepid)
  • Revision ID: james.westby@ubuntu.com-20080802114953-0qdeowgl63k42n2c
Tags: 0.82-4
http://bugs.debian.org/493303
* Fix a typo in the freetds-common description, ugh
* Versioned replaces of libct4 by freetds-common, since the current one
  obviously doesn't have overlapping files.
* tdsodbc: check for /var/lib/odbc existence before removing it in the
  postinst, since there are cases where it won't exist on upgrade (i.e.,
  if the driver was never enabled in the first place).  Closes: #493303.

Show diffs side-by-side

added added

removed removed

Lines of Context:
doc/doc/freetds-0.82/userguide/odbcombo.htm
 
1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
 
2
<HTML
 
3
><HEAD
 
4
><TITLE
 
5
>ODBC-combined configuration</TITLE
 
6
><META
 
7
NAME="GENERATOR"
 
8
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
 
9
REL="HOME"
 
10
TITLE="FreeTDS User Guide"
 
11
HREF="index.htm"><LINK
 
12
REL="UP"
 
13
TITLE="Preparing ODBC"
 
14
HREF="prepodbc.htm"><LINK
 
15
REL="PREVIOUS"
 
16
TITLE="ODBC-only configuration"
 
17
HREF="odbcinionly.htm"><LINK
 
18
REL="NEXT"
 
19
TITLE="Troubleshooting ODBC connections"
 
20
HREF="odbcdiagnose.htm"><LINK
 
21
REL="STYLESHEET"
 
22
TYPE="text/css"
 
23
HREF="userguide.css"></HEAD
 
24
><BODY
 
25
CLASS="SECT1"
 
26
BGCOLOR="#FFFFFF"
 
27
TEXT="#000000"
 
28
LINK="#0000FF"
 
29
VLINK="#840084"
 
30
ALINK="#0000FF"
 
31
><DIV
 
32
CLASS="NAVHEADER"
 
33
><TABLE
 
34
SUMMARY="Header navigation table"
 
35
WIDTH="100%"
 
36
BORDER="0"
 
37
CELLPADDING="0"
 
38
CELLSPACING="0"
 
39
><TR
 
40
><TH
 
41
COLSPAN="3"
 
42
ALIGN="center"
 
43
><SPAN
 
44
CLASS="PRODUCTNAME"
 
45
>FreeTDS</SPAN
 
46
> User Guide: A Guide to Installing, Configuring, and Running <SPAN
 
47
CLASS="PRODUCTNAME"
 
48
>FreeTDS</SPAN
 
49
></TH
 
50
></TR
 
51
><TR
 
52
><TD
 
53
WIDTH="10%"
 
54
ALIGN="left"
 
55
VALIGN="bottom"
 
56
><A
 
57
HREF="odbcinionly.htm"
 
58
ACCESSKEY="P"
 
59
>Prev</A
 
60
></TD
 
61
><TD
 
62
WIDTH="80%"
 
63
ALIGN="center"
 
64
VALIGN="bottom"
 
65
>Chapter 4. Preparing ODBC</TD
 
66
><TD
 
67
WIDTH="10%"
 
68
ALIGN="right"
 
69
VALIGN="bottom"
 
70
><A
 
71
HREF="odbcdiagnose.htm"
 
72
ACCESSKEY="N"
 
73
>Next</A
 
74
></TD
 
75
></TR
 
76
></TABLE
 
77
><HR
 
78
ALIGN="LEFT"
 
79
WIDTH="100%"></DIV
 
80
><DIV
 
81
CLASS="SECT1"
 
82
><H1
 
83
CLASS="SECT1"
 
84
><A
 
85
NAME="ODBCOMBO"
 
86
>ODBC-combined configuration</A
 
87
></H1
 
88
><P
 
89
>Like the DSN-less configuration, ODBC-combined keeps server properties in <TT
 
90
CLASS="FILENAME"
 
91
>freetds.conf</TT
 
92
>.  The difference is that your applications can refer to the server by its DSN.  To make that possible, the DSN entry in <TT
 
93
CLASS="FILENAME"
 
94
>odbc.ini</TT
 
95
> refers to the dataserver entry in <TT
 
96
CLASS="FILENAME"
 
97
>freetds.conf</TT
 
98
>.  
 
99
                        
 
100
<DIV
 
101
CLASS="EXAMPLE"
 
102
><A
 
103
NAME="E.G.SAMPLEODBCCOMBO"
 
104
></A
 
105
><P
 
106
><B
 
107
>Example 4-5. Sample ODBC-combined <TT
 
108
CLASS="FILENAME"
 
109
>odbc.ini</TT
 
110
> file</B
 
111
></P
 
112
><PRE
 
113
CLASS="PROGRAMLISTING"
 
114
>[ODBC Data Sources]<A
 
115
NAME="AEN1750"
 
116
HREF="#FTN.AEN1750"
 
117
><SPAN
 
118
CLASS="footnote"
 
119
>[1]</SPAN
 
120
></A
 
121
>
 
122
 JDBCdsn = Sybase JDBC Server
 
123
 
 
124
[JDBCdsn]
 
125
Driver          = /usr/local/freetds/lib/libtdsodbc.so
 
126
Description     = Sybase JDBC Server
 
127
Trace           = No
 
128
Servername      = JDBC<A
 
129
NAME="AEN1754"
 
130
HREF="#FTN.AEN1754"
 
131
><SPAN
 
132
CLASS="footnote"
 
133
>[2]</SPAN
 
134
></A
 
135
>
 
136
Database        = pubs2
 
137
 
 
138
[Default]
 
139
Driver          = /usr/local/freetds/lib/libtdsodbc.so</PRE
 
140
></DIV
 
141
>
 
142
<DIV
 
143
CLASS="EXAMPLE"
 
144
><A
 
145
NAME="E.G.SAMPLECOMBOFILE"
 
146
></A
 
147
><P
 
148
><B
 
149
>Example 4-6. Sample ODBC-combined <TT
 
150
CLASS="FILENAME"
 
151
>freetds.conf</TT
 
152
> file</B
 
153
></P
 
154
><PRE
 
155
CLASS="PROGRAMLISTING"
 
156
>;
 
157
; freetds.conf
 
158
;
 
159
[JDBC]
 
160
        host = jdbc.sybase.com
 
161
        port = 4444
 
162
        tds version = 5.0</PRE
 
163
></DIV
 
164
>
 
165
                        </P
 
166
><P
 
167
>With this arrangement, an application can connect to the server in two ways, via its DSN (<TT
 
168
CLASS="LITERAL"
 
169
>JDBCdsn</TT
 
170
>), or its dataserver name (<TT
 
171
CLASS="LITERAL"
 
172
>JDBC</TT
 
173
>).  
 
174
                        </P
 
175
></DIV
 
176
><H3
 
177
CLASS="FOOTNOTES"
 
178
>Notes</H3
 
179
><TABLE
 
180
BORDER="0"
 
181
CLASS="FOOTNOTES"
 
182
WIDTH="100%"
 
183
><TR
 
184
><TD
 
185
ALIGN="LEFT"
 
186
VALIGN="TOP"
 
187
WIDTH="5%"
 
188
><A
 
189
NAME="FTN.AEN1750"
 
190
HREF="odbcombo.htm#AEN1750"
 
191
><SPAN
 
192
CLASS="footnote"
 
193
>[1]</SPAN
 
194
></A
 
195
></TD
 
196
><TD
 
197
ALIGN="LEFT"
 
198
VALIGN="TOP"
 
199
WIDTH="95%"
 
200
><P
 
201
>Several DSNs might be listed here.  In this example, we have only one, <SPAN
 
202
CLASS="QUOTE"
 
203
>"JDBCdsn"</SPAN
 
204
>.  It matches the <TT
 
205
CLASS="LITERAL"
 
206
>[JDBCdsn]</TT
 
207
> entry later in the file.  </P
 
208
></TD
 
209
></TR
 
210
><TR
 
211
><TD
 
212
ALIGN="LEFT"
 
213
VALIGN="TOP"
 
214
WIDTH="5%"
 
215
><A
 
216
NAME="FTN.AEN1754"
 
217
HREF="odbcombo.htm#AEN1754"
 
218
><SPAN
 
219
CLASS="footnote"
 
220
>[2]</SPAN
 
221
></A
 
222
></TD
 
223
><TD
 
224
ALIGN="LEFT"
 
225
VALIGN="TOP"
 
226
WIDTH="95%"
 
227
><P
 
228
>Refers to the <TT
 
229
CLASS="LITERAL"
 
230
>[JDBC]</TT
 
231
> entry in  <TT
 
232
CLASS="FILENAME"
 
233
>freetds.conf</TT
 
234
>. </P
 
235
></TD
 
236
></TR
 
237
></TABLE
 
238
><DIV
 
239
CLASS="NAVFOOTER"
 
240
><HR
 
241
ALIGN="LEFT"
 
242
WIDTH="100%"><TABLE
 
243
SUMMARY="Footer navigation table"
 
244
WIDTH="100%"
 
245
BORDER="0"
 
246
CELLPADDING="0"
 
247
CELLSPACING="0"
 
248
><TR
 
249
><TD
 
250
WIDTH="33%"
 
251
ALIGN="left"
 
252
VALIGN="top"
 
253
><A
 
254
HREF="odbcinionly.htm"
 
255
ACCESSKEY="P"
 
256
>Prev</A
 
257
></TD
 
258
><TD
 
259
WIDTH="34%"
 
260
ALIGN="center"
 
261
VALIGN="top"
 
262
><A
 
263
HREF="index.htm"
 
264
ACCESSKEY="H"
 
265
>Home</A
 
266
></TD
 
267
><TD
 
268
WIDTH="33%"
 
269
ALIGN="right"
 
270
VALIGN="top"
 
271
><A
 
272
HREF="odbcdiagnose.htm"
 
273
ACCESSKEY="N"
 
274
>Next</A
 
275
></TD
 
276
></TR
 
277
><TR
 
278
><TD
 
279
WIDTH="33%"
 
280
ALIGN="left"
 
281
VALIGN="top"
 
282
>ODBC-only configuration</TD
 
283
><TD
 
284
WIDTH="34%"
 
285
ALIGN="center"
 
286
VALIGN="top"
 
287
><A
 
288
HREF="prepodbc.htm"
 
289
ACCESSKEY="U"
 
290
>Up</A
 
291
></TD
 
292
><TD
 
293
WIDTH="33%"
 
294
ALIGN="right"
 
295
VALIGN="top"
 
296
>Troubleshooting ODBC connections</TD
 
297
></TR
 
298
></TABLE
 
299
></DIV
 
300
></BODY
 
301
></HTML
 
302
>
 
 
b'\\ No newline at end of file'