FreeTDS API
 All Classes Files Functions Variables Typedefs Enumerations Enumerator Macros Groups Pages
tds.h
Go to the documentation of this file.
1 /* FreeTDS - Library of routines accessing Sybase and Microsoft databases
2  * Copyright (C) 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005 Brian Bruns
3  * Copyright (C) 2010, 2011 Frediano Ziglio
4  *
5  * This library is free software; you can redistribute it and/or
6  * modify it under the terms of the GNU Library General Public
7  * License as published by the Free Software Foundation; either
8  * version 2 of the License, or (at your option) any later version.
9  *
10  * This library is distributed in the hope that it will be useful,
11  * but WITHOUT ANY WARRANTY; without even the implied warranty of
12  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
13  * Library General Public License for more details.
14  *
15  * You should have received a copy of the GNU Library General Public
16  * License along with this library; if not, write to the
17  * Free Software Foundation, Inc., 59 Temple Place - Suite 330,
18  * Boston, MA 02111-1307, USA.
19  */
20 
21 #ifndef _tds_h_
22 #define _tds_h_
23 
24 /* $Id: tds.h,v 1.352.2.4 2011-08-12 16:29:36 freddy77 Exp $ */
25 
26 #include <stdarg.h>
27 #include <stdio.h>
28 #include <time.h>
29 
30 #if HAVE_NETINET_IN_H
31 #include <netinet/in.h>
32 #endif /* HAVE_NET_INET_IN_H */
33 #if HAVE_ARPA_INET_H
34 #include <arpa/inet.h>
35 #endif /* HAVE_ARPA_INET_H */
36 
37 /* forward declaration */
38 typedef struct tdsiconvinfo TDSICONV;
39 typedef struct tds_socket TDSSOCKET;
40 
41 #include "tdsver.h"
42 #include "tds_sysdep_public.h"
43 #ifdef _FREETDS_LIBRARY_SOURCE
44 #include "tds_sysdep_private.h"
45 #endif /* _FREETDS_LIBRARY_SOURCE */
46 
47 #if defined(__GNUC__) && __GNUC__ >= 4 && !defined(__MINGW32__)
48 #pragma GCC visibility push(hidden)
49 #endif
50 
51 #ifdef __cplusplus
52 extern "C"
53 {
54 #if 0
55 }
56 #endif
57 #endif
58 
65 {
66  const char *freetds_version; /* release version of FreeTDS */
67  const char *sysconfdir; /* location of freetds.conf */
68  const char *last_update; /* latest software_version date among the modules */
69  int msdblib; /* for MS style dblib */
70  int sybase_compat; /* enable increased Open Client binary compatibility */
71  int threadsafe; /* compile for thread safety default=no */
72  int libiconv; /* search for libiconv in DIR/include and DIR/lib */
73  const char *tdsver; /* TDS protocol version (4.2/4.6/5.0/7.0/8.0) 5.0 */
74  int iodbc; /* build odbc driver against iODBC in DIR */
75  int unixodbc; /* build odbc driver against unixODBC in DIR */
76 
78 
79 typedef struct tds_dstr {
80  char *dstr_s;
81  size_t dstr_size;
82 } DSTR;
83 
99 /*
100  * All references to data that touch the wire should use the following typedefs.
101  *
102  * If you have problems on 64-bit machines and the code is
103  * using a native datatype, please change it to use
104  * these. (In the TDS layer only, the API layers have their
105  * own typedefs which equate to these).
106  */
107 typedef char TDS_CHAR; /* 8-bit char */
108 typedef unsigned char TDS_UCHAR; /* 8-bit uchar */
109 typedef unsigned char TDS_TINYINT; /* 8-bit unsigned */
110 typedef tds_sysdep_int16_type TDS_SMALLINT; /* 16-bit int */
111 typedef unsigned tds_sysdep_int16_type TDS_USMALLINT; /* 16-bit unsigned */
112 typedef tds_sysdep_int32_type TDS_INT; /* 32-bit int */
113 typedef unsigned tds_sysdep_int32_type TDS_UINT; /* 32-bit unsigned */
114 typedef tds_sysdep_real32_type TDS_REAL; /* 32-bit real */
115 typedef tds_sysdep_real64_type TDS_FLOAT; /* 64-bit real */
116 typedef tds_sysdep_int64_type TDS_INT8; /* 64-bit integer */
117 typedef unsigned tds_sysdep_int64_type TDS_UINT8; /* 64-bit unsigned */
118 typedef tds_sysdep_intptr_type TDS_INTPTR;
119 
120 typedef struct tdsnumeric
121 {
122  unsigned char precision;
123  unsigned char scale;
124  unsigned char array[33];
125 } TDS_NUMERIC;
126 
127 typedef struct tdsoldmoney
128 {
129  TDS_INT mnyhigh;
130  TDS_UINT mnylow;
131 } TDS_OLD_MONEY;
132 
133 typedef union tdsmoney
134 {
136  TDS_INT8 mny;
137 } TDS_MONEY;
138 
139 typedef struct tdsmoney4
140 {
141  TDS_INT mny4;
142 } TDS_MONEY4;
143 
144 typedef struct tdsdatetime
145 {
146  TDS_INT dtdays;
147  TDS_INT dttime;
148 } TDS_DATETIME;
149 
150 typedef struct tdsdatetime4
151 {
152  TDS_USMALLINT days;
153  TDS_USMALLINT minutes;
154 } TDS_DATETIME4;
155 
156 typedef struct tdsvarbinary
157 {
158  TDS_SMALLINT len;
159  TDS_CHAR array[256];
160 } TDS_VARBINARY;
161 typedef struct tdsvarchar
162 {
163  TDS_SMALLINT len;
164  TDS_CHAR array[256];
165 } TDS_VARCHAR;
166 
167 typedef struct tdsunique
168 {
169  TDS_UINT Data1;
170  TDS_USMALLINT Data2;
171  TDS_USMALLINT Data3;
172  TDS_UCHAR Data4[8];
173 } TDS_UNIQUE;
174 
176 typedef struct tdsdaterec
177 {
178  TDS_INT year;
179  TDS_INT quarter;
180  TDS_INT month;
181  TDS_INT day;
182  TDS_INT dayofyear;
183  TDS_INT week;
184  TDS_INT weekday;
185  TDS_INT hour;
186  TDS_INT minute;
187  TDS_INT second;
188  TDS_INT millisecond;
189  TDS_INT tzone;
190 } TDSDATEREC;
191 
197 extern const int tds_numeric_bytes_per_prec[];
198 
199 #define TDS_SUCCEED 1
200 #define TDS_FAIL 0
201 #define TDS_NO_MORE_RESULTS 2
202 #define TDS_CANCELLED 3
203 
204 #define TDS_INT_CONTINUE 1
205 #define TDS_INT_CANCEL 2
206 #define TDS_INT_TIMEOUT 3
207 
208 
209 #define TDS_NO_COUNT -1
210 
211 #define TDS_ROW_RESULT 4040
212 #define TDS_PARAM_RESULT 4042
213 #define TDS_STATUS_RESULT 4043
214 #define TDS_MSG_RESULT 4044
215 #define TDS_COMPUTE_RESULT 4045
216 #define TDS_CMD_DONE 4046
217 #define TDS_CMD_SUCCEED 4047
218 #define TDS_CMD_FAIL 4048
219 #define TDS_ROWFMT_RESULT 4049
220 #define TDS_COMPUTEFMT_RESULT 4050
221 #define TDS_DESCRIBE_RESULT 4051
222 #define TDS_DONE_RESULT 4052
223 #define TDS_DONEPROC_RESULT 4053
224 #define TDS_DONEINPROC_RESULT 4054
225 #define TDS_OTHERS_RESULT 4055
226 
227 enum tds_token_results
228 {
229  TDS_TOKEN_RES_OTHERS,
230  TDS_TOKEN_RES_ROWFMT,
231  TDS_TOKEN_RES_COMPUTEFMT,
232  TDS_TOKEN_RES_PARAMFMT,
233  TDS_TOKEN_RES_DONE,
234  TDS_TOKEN_RES_ROW,
235  TDS_TOKEN_RES_COMPUTE,
236  TDS_TOKEN_RES_PROC,
237  TDS_TOKEN_RES_MSG
238 };
239 
240 #define TDS_TOKEN_FLAG(flag) TDS_RETURN_##flag = (1 << (TDS_TOKEN_RES_##flag*2)), TDS_STOPAT_##flag = (2 << (TDS_TOKEN_RES_##flag*2))
241 
242 enum tds_token_flags
243 {
244  TDS_HANDLE_ALL = 0,
245  TDS_TOKEN_FLAG(OTHERS),
246  TDS_TOKEN_FLAG(ROWFMT),
247  TDS_TOKEN_FLAG(COMPUTEFMT),
248  TDS_TOKEN_FLAG(PARAMFMT),
249  TDS_TOKEN_FLAG(DONE),
250  TDS_TOKEN_FLAG(ROW),
251  TDS_TOKEN_FLAG(COMPUTE),
252  TDS_TOKEN_FLAG(PROC),
253  TDS_TOKEN_FLAG(MSG),
254  TDS_TOKEN_RESULTS = TDS_RETURN_ROWFMT|TDS_RETURN_COMPUTEFMT|TDS_RETURN_DONE|TDS_STOPAT_ROW|TDS_STOPAT_COMPUTE|TDS_RETURN_PROC,
255  TDS_TOKEN_TRAILING = TDS_STOPAT_ROWFMT|TDS_STOPAT_COMPUTEFMT|TDS_STOPAT_ROW|TDS_STOPAT_COMPUTE|TDS_STOPAT_MSG|TDS_STOPAT_OTHERS
256 };
257 
262 {
265  , TDS_DONE_ERROR = 0x02
266  , TDS_DONE_INXACT = 0x04
267  , TDS_DONE_PROC = 0x08
268  , TDS_DONE_COUNT = 0x10
270  , TDS_DONE_EVENT = 0x40 /* part of an event notification. */
271  , TDS_DONE_SRVERROR = 0x100
273  /* after the above flags, a TDS_DONE packet has a field describing the state of the transaction */
274  , TDS_DONE_NO_TRAN = 0 /* No transaction in effect */
275  , TDS_DONE_TRAN_SUCCEED = 1 /* Transaction completed successfully */
276  , TDS_DONE_TRAN_PROGRESS= 2 /* Transaction in progress */
277  , TDS_DONE_STMT_ABORT = 3 /* A statement aborted */
278  , TDS_DONE_TRAN_ABORT = 4 /* Transaction aborted */
279 };
280 
281 
282 /*
283  * TDSERRNO is emitted by libtds to the client library's error handler
284  * (which may in turn call the client's error handler).
285  * These match the db-lib msgno, because the same values have the same meaning
286  * in db-lib and ODBC. ct-lib maps them to ct-lib numbers (todo).
287  */
288 typedef enum { TDSEOK = TDS_SUCCEED,
289  TDSEVERDOWN = 100,
290  TDSEICONVIU = 2400,
291  TDSEICONVAVAIL = 2401,
292  TDSEICONVO = 2402,
293  TDSEICONVI = 2403,
294  TDSEICONV2BIG = 2404,
295  TDSEPORTINSTANCE = 2500,
296  TDSESYNC = 20001,
297  TDSEFCON = 20002,
298  TDSETIME = 20003,
299  TDSEREAD = 20004,
300  TDSEWRIT = 20006,
301  TDSESOCK = 20008,
302  TDSECONN = 20009,
303  TDSEMEM = 20010,
304  TDSEINTF = 20012, /* Server name not found in interface file */
305  TDSEUHST = 20013, /* Unknown host machine name. */
306  TDSEPWD = 20014,
307  TDSESEOF = 20017,
308  TDSERPND = 20019,
309  TDSEBTOK = 20020,
310  TDSEOOB = 20022,
311  TDSECLOS = 20056,
312  TDSEUSCT = 20058,
313  TDSEUTDS = 20146,
314  TDSEEUNR = 20185,
315  TDSECAP = 20203,
316  TDSENEG = 20210,
317  TDSEUMSG = 20212,
318  TDSECAPTYP = 20213,
319  TDSEBPROBADTYP = 20250,
320  TDSECLOSEIN = 20292
321 } TDSERRNO;
322 
323 #define TDS5_PARAMFMT2_TOKEN 32 /* 0x20 */
324 #define TDS_LANGUAGE_TOKEN 33 /* 0x21 TDS 5.0 only */
325 #define TDS_ORDERBY2_TOKEN 34 /* 0x22 */
326 #define TDS_ROWFMT2_TOKEN 97 /* 0x61 TDS 5.0 only */
327 #define TDS_LOGOUT_TOKEN 113 /* 0x71 TDS 5.0 only? ct_close() */
328 #define TDS_RETURNSTATUS_TOKEN 121 /* 0x79 */
329 #define TDS_PROCID_TOKEN 124 /* 0x7C TDS 4.2 only - TDS_PROCID */
330 #define TDS7_RESULT_TOKEN 129 /* 0x81 TDS 7.0 only */
331 #define TDS7_COMPUTE_RESULT_TOKEN 136 /* 0x88 TDS 7.0 only */
332 #define TDS_COLNAME_TOKEN 160 /* 0xA0 TDS 4.2 only */
333 #define TDS_COLFMT_TOKEN 161 /* 0xA1 TDS 4.2 only - TDS_COLFMT */
334 #define TDS_DYNAMIC2_TOKEN 163 /* 0xA3 */
335 #define TDS_TABNAME_TOKEN 164 /* 0xA4 */
336 #define TDS_COLINFO_TOKEN 165 /* 0xA5 */
337 #define TDS_OPTIONCMD_TOKEN 166 /* 0xA6 */
338 #define TDS_COMPUTE_NAMES_TOKEN 167 /* 0xA7 */
339 #define TDS_COMPUTE_RESULT_TOKEN 168 /* 0xA8 */
340 #define TDS_ORDERBY_TOKEN 169 /* 0xA9 TDS_ORDER */
341 #define TDS_ERROR_TOKEN 170 /* 0xAA */
342 #define TDS_INFO_TOKEN 171 /* 0xAB */
343 #define TDS_PARAM_TOKEN 172 /* 0xAC RETURNVALUE? */
344 #define TDS_LOGINACK_TOKEN 173 /* 0xAD */
345 #define TDS_CONTROL_TOKEN 174 /* 0xAE TDS_CONTROL */
346 #define TDS_ROW_TOKEN 209 /* 0xD1 */
347 #define TDS_NBC_ROW_TOKEN 210 /* 0xD2 as of TDS 7.3.B */ /* not implemented */
348 #define TDS_CMP_ROW_TOKEN 211 /* 0xD3 */
349 #define TDS5_PARAMS_TOKEN 215 /* 0xD7 TDS 5.0 only */
350 #define TDS_CAPABILITY_TOKEN 226 /* 0xE2 */
351 #define TDS_ENVCHANGE_TOKEN 227 /* 0xE3 */
352 #define TDS_EED_TOKEN 229 /* 0xE5 */
353 #define TDS_DBRPC_TOKEN 230 /* 0xE6 */
354 #define TDS5_DYNAMIC_TOKEN 231 /* 0xE7 TDS 5.0 only */
355 #define TDS5_PARAMFMT_TOKEN 236 /* 0xEC TDS 5.0 only */
356 #define TDS_AUTH_TOKEN 237 /* 0xED TDS 7.0 only */
357 #define TDS_RESULT_TOKEN 238 /* 0xEE */
358 #define TDS_DONE_TOKEN 253 /* 0xFD TDS_DONE */
359 #define TDS_DONEPROC_TOKEN 254 /* 0xFE TDS_DONEPROC */
360 #define TDS_DONEINPROC_TOKEN 255 /* 0xFF TDS_DONEINPROC */
361 
362 /* CURSOR support: TDS 5.0 only*/
363 #define TDS_CURCLOSE_TOKEN 128 /* 0x80 TDS 5.0 only */
364 #define TDS_CURDELETE_TOKEN 129 /* 0x81 TDS 5.0 only */
365 #define TDS_CURFETCH_TOKEN 130 /* 0x82 TDS 5.0 only */
366 #define TDS_CURINFO_TOKEN 131 /* 0x83 TDS 5.0 only */
367 #define TDS_CUROPEN_TOKEN 132 /* 0x84 TDS 5.0 only */
368 #define TDS_CURDECLARE_TOKEN 134 /* 0x86 TDS 5.0 only */
369 
370 enum {
371  TDS_CUR_ISTAT_UNUSED = 0x00,
372  TDS_CUR_ISTAT_DECLARED = 0x01,
373  TDS_CUR_ISTAT_OPEN = 0x02,
374  TDS_CUR_ISTAT_CLOSED = 0x04,
375  TDS_CUR_ISTAT_RDONLY = 0x08,
376  TDS_CUR_ISTAT_UPDATABLE = 0x10,
377  TDS_CUR_ISTAT_ROWCNT = 0x20,
378  TDS_CUR_ISTAT_DEALLOC = 0x40
379 };
380 
381 /* http://jtds.sourceforge.net/apiCursors.html */
382 /* Cursor scroll option, must be one of 0x01 - 0x10, OR'd with other bits */
383 enum {
384  TDS_CUR_TYPE_KEYSET = 0x0001, /* default */
385  TDS_CUR_TYPE_DYNAMIC = 0x0002,
386  TDS_CUR_TYPE_FORWARD = 0x0004,
387  TDS_CUR_TYPE_STATIC = 0x0008,
388  TDS_CUR_TYPE_FASTFORWARDONLY = 0x0010,
389  TDS_CUR_TYPE_PARAMETERIZED = 0x1000,
390  TDS_CUR_TYPE_AUTO_FETCH = 0x2000
391 };
392 
393 enum {
394  TDS_CUR_CONCUR_READ_ONLY = 1,
395  TDS_CUR_CONCUR_SCROLL_LOCKS = 2,
396  TDS_CUR_CONCUR_OPTIMISTIC = 4, /* default */
397  TDS_CUR_CONCUR_OPTIMISTIC_VALUES = 8
398 };
399 
400 /* environment type field */
401 #define TDS_ENV_DATABASE 1
402 #define TDS_ENV_LANG 2
403 #define TDS_ENV_CHARSET 3
404 #define TDS_ENV_PACKSIZE 4
405 #define TDS_ENV_LCID 5
406 #define TDS_ENV_SQLCOLLATION 7
407 #define TDS_ENV_BEGINTRANS 8
408 #define TDS_ENV_COMMITTRANS 9
409 #define TDS_ENV_ROLLBACKTRANS 10
410 
411 /* string types */
412 #define TDS_NULLTERM -9
413 
414 /* Microsoft internal stored procedure id's */
415 
416 #define TDS_SP_CURSOR 1
417 #define TDS_SP_CURSOROPEN 2
418 #define TDS_SP_CURSORPREPARE 3
419 #define TDS_SP_CURSOREXECUTE 4
420 #define TDS_SP_CURSORPREPEXEC 5
421 #define TDS_SP_CURSORUNPREPARE 6
422 #define TDS_SP_CURSORFETCH 7
423 #define TDS_SP_CURSOROPTION 8
424 #define TDS_SP_CURSORCLOSE 9
425 #define TDS_SP_EXECUTESQL 10
426 #define TDS_SP_PREPARE 11
427 #define TDS_SP_EXECUTE 12
428 #define TDS_SP_PREPEXEC 13
429 #define TDS_SP_PREPEXECRPC 14
430 #define TDS_SP_UNPREPARE 15
431 /*
432  * <rant> Sybase does an awful job of this stuff, non null ints of size 1 2
433  * and 4 have there own codes but nullable ints are lumped into INTN
434  * sheesh! </rant>
435  */
436 typedef enum
437 {
438  SYBCHAR = 47, /* 0x2F */
439 #define SYBCHAR SYBCHAR
440  SYBVARCHAR = 39, /* 0x27 */
441 #define SYBVARCHAR SYBVARCHAR
442  SYBINTN = 38, /* 0x26 */
443 #define SYBINTN SYBINTN
444  SYBINT1 = 48, /* 0x30 */
445 #define SYBINT1 SYBINT1
446  SYBINT2 = 52, /* 0x34 */
447 #define SYBINT2 SYBINT2
448  SYBINT4 = 56, /* 0x38 */
449 #define SYBINT4 SYBINT4
450  SYBFLT8 = 62, /* 0x3E */
451 #define SYBFLT8 SYBFLT8
452  SYBDATETIME = 61, /* 0x3D */
453 #define SYBDATETIME SYBDATETIME
454  SYBBIT = 50, /* 0x32 */
455 #define SYBBIT SYBBIT
456  SYBTEXT = 35, /* 0x23 */
457 #define SYBTEXT SYBTEXT
458  SYBNTEXT = 99, /* 0x63 */
459 #define SYBNTEXT SYBNTEXT
460  SYBIMAGE = 34, /* 0x22 */
461 #define SYBIMAGE SYBIMAGE
462  SYBMONEY4 = 122, /* 0x7A */
463 #define SYBMONEY4 SYBMONEY4
464  SYBMONEY = 60, /* 0x3C */
465 #define SYBMONEY SYBMONEY
466  SYBDATETIME4 = 58, /* 0x3A */
467 #define SYBDATETIME4 SYBDATETIME4
468  SYBREAL = 59, /* 0x3B */
469 #define SYBREAL SYBREAL
470  SYBBINARY = 45, /* 0x2D */
471 #define SYBBINARY SYBBINARY
472  SYBVOID = 31, /* 0x1F */
473 #define SYBVOID SYBVOID
474  SYBVARBINARY = 37, /* 0x25 */
475 #define SYBVARBINARY SYBVARBINARY
476  SYBBITN = 104, /* 0x68 */
477 #define SYBBITN SYBBITN
478  SYBNUMERIC = 108, /* 0x6C */
479 #define SYBNUMERIC SYBNUMERIC
480  SYBDECIMAL = 106, /* 0x6A */
481 #define SYBDECIMAL SYBDECIMAL
482  SYBFLTN = 109, /* 0x6D */
483 #define SYBFLTN SYBFLTN
484  SYBMONEYN = 110, /* 0x6E */
485 #define SYBMONEYN SYBMONEYN
486  SYBDATETIMN = 111, /* 0x6F */
487 #define SYBDATETIMN SYBDATETIMN
488 
489 /*
490  * MS only types
491  */
492  SYBNVARCHAR = 103, /* 0x67 */
493 #define SYBNVARCHAR SYBNVARCHAR
494  SYBINT8 = 127, /* 0x7F */
495 #define SYBINT8 SYBINT8
496  XSYBCHAR = 175, /* 0xAF */
497 #define XSYBCHAR XSYBCHAR
498  XSYBVARCHAR = 167, /* 0xA7 */
499 #define XSYBVARCHAR XSYBVARCHAR
500  XSYBNVARCHAR = 231, /* 0xE7 */
501 #define XSYBNVARCHAR XSYBNVARCHAR
502  XSYBNCHAR = 239, /* 0xEF */
503 #define XSYBNCHAR XSYBNCHAR
504  XSYBVARBINARY = 165, /* 0xA5 */
505 #define XSYBVARBINARY XSYBVARBINARY
506  XSYBBINARY = 173, /* 0xAD */
507 #define XSYBBINARY XSYBBINARY
508  SYBUNIQUE = 36, /* 0x24 */
509 #define SYBUNIQUE SYBUNIQUE
510  SYBVARIANT = 98, /* 0x62 */
511 #define SYBVARIANT SYBVARIANT
512  SYBMSUDT = 240, /* 0xF0 */
513 #define SYBMSUDT SYBMSUDT
514  SYBMSXML = 241, /* 0xF1 */
515 #define SYBMSXML SYBMSXML
516 
517 /*
518  * Sybase only types
519  */
520  SYBLONGBINARY = 225, /* 0xE1 */
521 #define SYBLONGBINARY SYBLONGBINARY
522  SYBUINT1 = 64, /* 0x40 */
523 #define SYBUINT1 SYBUINT1
524  SYBUINT2 = 65, /* 0x41 */
525 #define SYBUINT2 SYBUINT2
526  SYBUINT4 = 66, /* 0x42 */
527 #define SYBUINT4 SYBUINT4
528  SYBUINT8 = 67, /* 0x43 */
529 #define SYBUINT8 SYBUINT8
530  SYBBLOB = 36, /* 0x24 */
531 #define SYBBLOB SYBBLOB
532  SYBBOUNDARY = 104, /* 0x68 */
533 #define SYBBOUNDARY SYBBOUNDARY
534  SYBDATE = 49, /* 0x31 */
535 #define SYBDATE SYBDATE
536  SYBDATEN = 123, /* 0x7B */
537 #define SYBDATEN SYBDATEN
538  SYB5INT8 = 191, /* 0xBF */
539 #define SYB5INT8 SYB5INT8
540  SYBINTERVAL = 46, /* 0x2E */
541 #define SYBINTERVAL SYBINTERVAL
542  SYBLONGCHAR = 175, /* 0xAF */
543 #define SYBLONGCHAR SYBLONGCHAR
544  SYBSENSITIVITY = 103, /* 0x67 */
545 #define SYBSENSITIVITY SYBSENSITIVITY
546  SYBSINT1 = 176, /* 0xB0 */
547 #define SYBSINT1 SYBSINT1
548  SYBTIME = 51, /* 0x33 */
549 #define SYBTIME SYBTIME
550  SYBTIMEN = 147, /* 0x93 */
551 #define SYBTIMEN SYBTIMEN
552  SYBUINTN = 68, /* 0x44 */
553 #define SYBUINTN SYBUINTN
554  SYBUNITEXT = 174, /* 0xAE */
555 #define SYBUNITEXT SYBUNITEXT
556  SYBXML = 163, /* 0xA3 */
557 #define SYBXML SYBXML
558 
559 } TDS_SERVER_TYPE;
560 
561 
562 typedef enum
563 {
564  USER_UNICHAR_TYPE = 34, /* 0x22 */
565  USER_UNIVARCHAR_TYPE = 35 /* 0x23 */
566 } TDS_USER_TYPE;
567 
568 #define SYBAOPCNT 0x4b
569 #define SYBAOPCNTU 0x4c
570 #define SYBAOPSUM 0x4d
571 #define SYBAOPSUMU 0x4e
572 #define SYBAOPAVG 0x4f
573 #define SYBAOPAVGU 0x50
574 #define SYBAOPMIN 0x51
575 #define SYBAOPMAX 0x52
576 
577 /* mssql2k compute operator */
578 #define SYBAOPCNT_BIG 0x09
579 #define SYBAOPSTDEV 0x30
580 #define SYBAOPSTDEVP 0x31
581 #define SYBAOPVAR 0x32
582 #define SYBAOPVARP 0x33
583 #define SYBAOPCHECKSUM_AGG 0x72
584 
585 
589 typedef enum
590 {
591  TDS_OPT_SET = 1 /* Set an option. */
592  , TDS_OPT_DEFAULT = 2 /* Set option to its default value. */
593  , TDS_OPT_LIST = 3 /* Request current setting of a specific option. */
594  , TDS_OPT_INFO = 4 /* Report current setting of a specific option. */
596 
597 typedef enum
598 {
599  TDS_OPT_DATEFIRST = 1 /* 0x01 */
600  , TDS_OPT_TEXTSIZE = 2 /* 0x02 */
601  , TDS_OPT_STAT_TIME = 3 /* 0x03 */
602  , TDS_OPT_STAT_IO = 4 /* 0x04 */
603  , TDS_OPT_ROWCOUNT = 5 /* 0x05 */
604  , TDS_OPT_NATLANG = 6 /* 0x06 */
605  , TDS_OPT_DATEFORMAT = 7 /* 0x07 */
606  , TDS_OPT_ISOLATION = 8 /* 0x08 */
607  , TDS_OPT_AUTHON = 9 /* 0x09 */
608  , TDS_OPT_CHARSET = 10 /* 0x0a */
609  , TDS_OPT_SHOWPLAN = 13 /* 0x0d */
610  , TDS_OPT_NOEXEC = 14 /* 0x0e */
611  , TDS_OPT_ARITHIGNOREON = 15 /* 0x0f */
612  , TDS_OPT_ARITHABORTON = 17 /* 0x11 */
613  , TDS_OPT_PARSEONLY = 18 /* 0x12 */
614  , TDS_OPT_GETDATA = 20 /* 0x14 */
615  , TDS_OPT_NOCOUNT = 21 /* 0x15 */
616  , TDS_OPT_FORCEPLAN = 23 /* 0x17 */
617  , TDS_OPT_FORMATONLY = 24 /* 0x18 */
618  , TDS_OPT_CHAINXACTS = 25 /* 0x19 */
619  , TDS_OPT_CURCLOSEONXACT = 26 /* 0x1a */
620  , TDS_OPT_FIPSFLAG = 27 /* 0x1b */
621  , TDS_OPT_RESTREES = 28 /* 0x1c */
622  , TDS_OPT_IDENTITYON = 29 /* 0x1d */
623  , TDS_OPT_CURREAD = 30 /* 0x1e */
624  , TDS_OPT_CURWRITE = 31 /* 0x1f */
625  , TDS_OPT_IDENTITYOFF = 32 /* 0x20 */
626  , TDS_OPT_AUTHOFF = 33 /* 0x21 */
627  , TDS_OPT_ANSINULL = 34 /* 0x22 */
628  , TDS_OPT_QUOTED_IDENT = 35 /* 0x23 */
629  , TDS_OPT_ARITHIGNOREOFF = 36 /* 0x24 */
630  , TDS_OPT_ARITHABORTOFF = 37 /* 0x25 */
631  , TDS_OPT_TRUNCABORT = 38 /* 0x26 */
632 } TDS_OPTION;
633 
634 typedef union tds_option_arg
635 {
636  TDS_TINYINT ti;
637  TDS_INT i;
638  TDS_CHAR *c;
640 
641 enum {
642  TDS_OPT_ARITHOVERFLOW = 0x01,
643  TDS_OPT_NUMERICTRUNC = 0x02
644 };
645 
646 enum TDS_OPT_DATEFIRST_CHOICE
647 {
648  TDS_OPT_MONDAY = 1, TDS_OPT_TUESDAY = 2, TDS_OPT_WEDNESDAY = 3, TDS_OPT_THURSDAY = 4, TDS_OPT_FRIDAY = 5, TDS_OPT_SATURDAY =
649  6, TDS_OPT_SUNDAY = 7
650 };
651 
652 enum TDS_OPT_DATEFORMAT_CHOICE
653 {
654  TDS_OPT_FMTMDY = 1, TDS_OPT_FMTDMY = 2, TDS_OPT_FMTYMD = 3, TDS_OPT_FMTYDM = 4, TDS_OPT_FMTMYD = 5, TDS_OPT_FMTDYM = 6
655 };
656 enum TDS_OPT_ISOLATION_CHOICE
657 {
658  TDS_OPT_LEVEL1 = 1, TDS_OPT_LEVEL3 = 3
659 };
660 
661 typedef enum tds_packet_type
662 {
663  TDS_QUERY = 1,
664  TDS_LOGIN = 2,
665  TDS_RPC = 3,
666  TDS_REPLY = 4,
667  TDS_CANCEL = 6,
668  TDS_BULK = 7,
669  TDS_NORMAL = 15,
670  TDS7_LOGIN = 16,
671  TDS7_AUTH = 17,
672  TDS8_PRELOGIN = 18
673 } TDS_PACKET_TYPE;
674 
675 typedef enum tds_encryption_level {
676  TDS_ENCRYPTION_OFF, TDS_ENCRYPTION_REQUEST, TDS_ENCRYPTION_REQUIRE
677 } TDS_ENCRYPTION_LEVEL;
678 
679 #define TDS_ZERO_FREE(x) do {free((x)); (x) = NULL;} while(0)
680 #define TDS_VECTOR_SIZE(x) (sizeof(x)/sizeof(x[0]))
681 
682 #if defined(__GNUC__) && __GNUC__ >= 3
683 # define TDS_LIKELY(x) __builtin_expect(!!(x), 1)
684 # define TDS_UNLIKELY(x) __builtin_expect(!!(x), 0)
685 #else
686 # define TDS_LIKELY(x) (x)
687 # define TDS_UNLIKELY(x) (x)
688 #endif
689 
690 /*
691  * TODO use system macros for optimization
692  * See mcrypt for reference and linux kernel source for optimization
693  * check if unaligned access and use fast write/read when implemented
694  */
695 #define TDS_BYTE_SWAP16(value) \
696  (((((unsigned short)value)<<8) & 0xFF00) | \
697  ((((unsigned short)value)>>8) & 0x00FF))
698 
699 #define TDS_BYTE_SWAP32(value) \
700  (((((unsigned long)value)<<24) & 0xFF000000) | \
701  ((((unsigned long)value)<< 8) & 0x00FF0000) | \
702  ((((unsigned long)value)>> 8) & 0x0000FF00) | \
703  ((((unsigned long)value)>>24) & 0x000000FF))
704 
705 #define is_end_token(x) (x==TDS_DONE_TOKEN || \
706  x==TDS_DONEPROC_TOKEN || \
707  x==TDS_DONEINPROC_TOKEN)
708 
709 #define is_hard_end_token(x) (x==TDS_DONE_TOKEN || \
710  x==TDS_DONEPROC_TOKEN)
711 
712 #define is_msg_token(x) (x==TDS_INFO_TOKEN || \
713  x==TDS_ERROR_TOKEN || \
714  x==TDS_EED_TOKEN)
715 
716 #define is_result_token(x) (x==TDS_RESULT_TOKEN || \
717  x==TDS_ROWFMT2_TOKEN || \
718  x==TDS7_RESULT_TOKEN || \
719  x==TDS_COLFMT_TOKEN || \
720  x==TDS_COLNAME_TOKEN || \
721  x==TDS_RETURNSTATUS_TOKEN)
722 
723 /* FIXME -- not a complete list */
724 #define is_fixed_type(x) (x==SYBINT1 || \
725  x==SYBINT2 || \
726  x==SYBINT4 || \
727  x==SYBINT8 || \
728  x==SYBREAL || \
729  x==SYBFLT8 || \
730  x==SYBDATETIME || \
731  x==SYBDATETIME4 || \
732  x==SYBBIT || \
733  x==SYBMONEY || \
734  x==SYBMONEY4 || \
735  x==SYBVOID || \
736  x==SYBUNIQUE)
737 #define is_nullable_type(x) ( \
738  x==SYBBITN || \
739  x==SYBINTN || \
740  x==SYBFLTN || \
741  x==SYBMONEYN || \
742  x==SYBDATETIMN || \
743  x==SYBVARCHAR || \
744  x==SYBVARBINARY || \
745  x==SYBTEXT || \
746  x==SYBNTEXT || \
747  x==SYBIMAGE)
748 
749 #define is_variable_type(x) ( \
750  (x)==SYBTEXT || \
751  (x)==SYBIMAGE || \
752  (x)==SYBNTEXT || \
753  (x)==SYBCHAR || \
754  (x)==SYBVARCHAR || \
755  (x)==SYBBINARY || \
756  (x)==SYBVARBINARY || \
757  (x)==SYBLONGBINARY || \
758  (x)==XSYBCHAR || \
759  (x)==XSYBVARCHAR || \
760  (x)==XSYBNVARCHAR || \
761  (x)==XSYBNCHAR)
762 
763 #define is_blob_type(x) (x==SYBTEXT || x==SYBIMAGE || x==SYBNTEXT)
764 #define is_blob_col(x) ((x)->column_varint_size > 2)
765 /* large type means it has a two byte size field */
766 /* define is_large_type(x) (x>128) */
767 #define is_numeric_type(x) (x==SYBNUMERIC || x==SYBDECIMAL)
768 #define is_unicode_type(x) (x==XSYBNVARCHAR || x==XSYBNCHAR || x==SYBNTEXT || x==SYBMSXML)
769 #define is_collate_type(x) (x==XSYBVARCHAR || x==XSYBCHAR || x==SYBTEXT || x==XSYBNVARCHAR || x==XSYBNCHAR || x==SYBNTEXT)
770 #define is_ascii_type(x) ( x==XSYBCHAR || x==XSYBVARCHAR || x==SYBTEXT || x==SYBCHAR || x==SYBVARCHAR)
771 #define is_char_type(x) (is_unicode_type(x) || is_ascii_type(x))
772 #define is_similar_type(x, y) ((is_char_type(x) && is_char_type(y)) || ((is_unicode_type(x) && is_unicode_type(y))))
773 
774 
775 #define TDS_MAX_CAPABILITY 22
776 #define MAXPRECISION 77
777 #define TDS_MAX_CONN 4096
778 #define TDS_MAX_DYNID_LEN 30
779 
780 /* defaults to use if no others are found */
781 #define TDS_DEF_SERVER "SYBASE"
782 #define TDS_DEF_BLKSZ 512
783 #define TDS_DEF_CHARSET "iso_1"
784 #define TDS_DEF_LANG "us_english"
785 #if TDS42
786 #define TDS_DEFAULT_VERSION 0x402
787 #define TDS_DEF_PORT 1433
788 #elif TDS46
789 #define TDS_DEFAULT_VERSION 0x406
790 #define TDS_DEF_PORT 4000
791 #elif TDS70
792 #define TDS_DEFAULT_VERSION 0x700
793 #define TDS_DEF_PORT 1433
794 #elif TDS71
795 #define TDS_DEFAULT_VERSION 0x701
796 #define TDS_DEF_PORT 1433
797 #elif TDS72
798 #define TDS_DEFAULT_VERSION 0x702
799 #define TDS_DEF_PORT 1433
800 #else
801 #define TDS_DEFAULT_VERSION 0x500
802 #define TDS_DEF_PORT 4000
803 #endif
804 
805 /* normalized strings from freetds.conf file */
806 #define TDS_STR_VERSION "tds version"
807 #define TDS_STR_BLKSZ "initial block size"
808 #define TDS_STR_SWAPDT "swap broken dates"
809 #define TDS_STR_DUMPFILE "dump file"
810 #define TDS_STR_DEBUGLVL "debug level"
811 #define TDS_STR_DEBUGFLAGS "debug flags"
812 #define TDS_STR_TIMEOUT "timeout"
813 #define TDS_STR_QUERY_TIMEOUT "query timeout"
814 #define TDS_STR_CONNTIMEOUT "connect timeout"
815 #define TDS_STR_HOSTNAME "hostname"
816 #define TDS_STR_HOST "host"
817 #define TDS_STR_PORT "port"
818 #define TDS_STR_TEXTSZ "text size"
819 /* for big endian hosts */
820 #define TDS_STR_EMUL_LE "emulate little endian"
821 #define TDS_STR_CHARSET "charset"
822 #define TDS_STR_CLCHARSET "client charset"
823 #define TDS_STR_LANGUAGE "language"
824 #define TDS_STR_APPENDMODE "dump file append"
825 #define TDS_STR_DATEFMT "date format"
826 #define TDS_STR_INSTANCE "instance"
827 #define TDS_STR_ASA_DATABASE "asa database"
828 #define TDS_STR_ENCRYPTION "encryption"
829 #define TDS_STR_USENTLMV2 "use ntlmv2"
830 /* conf values */
831 #define TDS_STR_ENCRYPTION_OFF "off"
832 #define TDS_STR_ENCRYPTION_REQUEST "request"
833 #define TDS_STR_ENCRYPTION_REQUIRE "require"
834 /* Defines to enable optional GSSAPI delegation */
835 #define TDS_GSSAPI_DELEGATION "enable gssapi delegation"
836 /* Kerberos realm name */
837 #define TDS_STR_REALM "realm"
838 
839 
840 /* TODO do a better check for alignment than this */
841 typedef union
842 {
843  void *p;
844  int i;
846 
847 #define TDS_ALIGN_SIZE sizeof(tds_align_struct)
848 
849 #define TDS_MAX_LOGIN_STR_SZ 30
850 typedef struct tds_login
851 {
852  DSTR server_name;
853  int port;
854  TDS_USMALLINT tds_version; /* TDS version */
855  int block_size;
856  DSTR language; /* e.g. us-english */
857  DSTR server_charset; /* e.g. iso_1 */
858  TDS_INT connect_timeout;
859  DSTR client_host_name;
860  DSTR app_name;
861  DSTR user_name;
862  DSTR password;
863 
864  DSTR library; /* Ct-Library, DB-Library, TDS-Library or ODBC */
865  TDS_TINYINT encryption_level;
866 
867  TDS_INT query_timeout;
868  unsigned char capabilities[TDS_MAX_CAPABILITY];
869  DSTR client_charset;
870  DSTR database;
871  unsigned int bulk_copy:1;
872  unsigned int suppress_language:1;
873 } TDSLOGIN;
874 
875 typedef struct tds_connection
876 {
877  /* first part of structure is the same of login one */
879  int port;
880  TDS_USMALLINT tds_version;
881  int block_size;
882  DSTR language;
884  TDS_INT connect_timeout;
885  DSTR client_host_name;
886  DSTR server_host_name;
888  DSTR app_name;
891  DSTR library;
892  TDS_TINYINT encryption_level;
893 
894  TDS_INT query_timeout;
895  unsigned char capabilities[TDS_MAX_CAPABILITY];
896  unsigned char option_flag2;
897  DSTR client_charset;
898 
900  DSTR instance_name;
901  DSTR database;
902  DSTR dump_file;
903  int debug_flags;
904  int text_size;
905  unsigned int broken_dates:1;
906  unsigned int emul_little_endian:1;
907  unsigned int bulk_copy:1;
908  unsigned int suppress_language:1;
909  unsigned int gssapi_use_delegation:1;
910  unsigned int use_ntlmv2:1;
911 } TDSCONNECTION;
912 
913 typedef struct tds_locale
914 {
915  char *language;
916  char *server_charset;
917  char *date_fmt;
918 } TDSLOCALE;
919 
924 typedef struct tds_blob
925 {
926  TDS_CHAR *textvalue;
927  TDS_CHAR textptr[16];
928  TDS_CHAR timestamp[8];
929 } TDSBLOB;
930 
934 typedef struct tds_variant
935 {
936  /* this MUST have same position and place of textvalue in tds_blob */
937  TDS_CHAR *data;
938  TDS_INT size;
939  TDS_INT data_len;
940  TDS_UCHAR type;
941  TDS_UCHAR collation[5];
942 } TDSVARIANT;
943 
947 typedef struct
948 {
949  TDS_USMALLINT locale_id; /* master..syslanguages.lcid */
950  TDS_USMALLINT flags;
951  TDS_UCHAR charset_id; /* or zero */
953 
954 /* SF stands for "sort flag" */
955 #define TDS_SF_BIN (TDS_USMALLINT) 0x100
956 #define TDS_SF_WIDTH_INSENSITIVE (TDS_USMALLINT) 0x080
957 #define TDS_SF_KATATYPE_INSENSITIVE (TDS_USMALLINT) 0x040
958 #define TDS_SF_ACCENT_SENSITIVE (TDS_USMALLINT) 0x020
959 #define TDS_SF_CASE_INSENSITIVE (TDS_USMALLINT) 0x010
960 
961 /* UT stands for user type */
962 #define TDS_UT_TIMESTAMP 80
963 
964 
969 typedef struct tds_encoding
970 {
971  const char *name;
972  unsigned char min_bytes_per_char;
973  unsigned char max_bytes_per_char;
974  unsigned char canonic;
975 } TDS_ENCODING;
976 
977 typedef struct tds_bcpcoldata
978 {
979  TDS_UCHAR *data;
980  TDS_INT datalen;
981  TDS_INT is_null;
982 } BCPCOLDATA;
983 
984 
985 enum
986 { TDS_SYSNAME_SIZE = 512 };
987 
991 typedef struct tds_column
992 {
993  TDS_SMALLINT column_type;
998  TDS_INT column_usertype;
999  TDS_INT column_flags;
1000 
1001  TDS_INT column_size;
1003  TDS_TINYINT column_varint_size;
1005  TDS_TINYINT column_prec;
1006  TDS_TINYINT column_scale;
1008  TDS_SMALLINT column_namelen;
1009  TDS_SMALLINT table_namelen;
1010  struct
1011  {
1012  TDS_SMALLINT column_type;
1013  TDS_INT column_size;
1014  } on_server;
1015 
1018  TDS_CHAR table_name[TDS_SYSNAME_SIZE];
1019  TDS_CHAR column_name[TDS_SYSNAME_SIZE];
1020  char * table_column_name;
1021 
1022  unsigned char *column_data;
1023  void (*column_data_free)(struct tds_column *column);
1024  unsigned int column_nullable:1;
1025  unsigned int column_writeable:1;
1026  unsigned int column_identity:1;
1027  unsigned int column_key:1;
1028  unsigned int column_hidden:1;
1029  unsigned int column_output:1;
1030  unsigned int column_timestamp:1;
1031  TDS_UCHAR column_collation[5];
1032 
1033  /* additional fields flags for compute results */
1034  TDS_TINYINT column_operator;
1035  TDS_SMALLINT column_operand;
1036 
1037  /* FIXME this is data related, not column */
1040 
1041  /* related to binding or info stored by client libraries */
1042  /* FIXME find a best place to store these data, some are unused */
1043  TDS_SMALLINT column_bindtype;
1044  TDS_SMALLINT column_bindfmt;
1045  TDS_UINT column_bindlen;
1046  TDS_SMALLINT *column_nullbind;
1047  TDS_CHAR *column_varaddr;
1048  TDS_INT *column_lenbind;
1049  TDS_INT column_textpos;
1050  TDS_INT column_text_sqlgetdatapos;
1051  TDS_CHAR column_text_sqlputdatainfo;
1052 
1053  BCPCOLDATA *bcp_column_data;
1063  TDS_INT bcp_term_len;
1064  TDS_CHAR *bcp_terminator;
1065 } TDSCOLUMN;
1066 
1067 
1069 typedef struct tds_result_info
1070 {
1071  /* TODO those fields can became a struct */
1072  TDS_SMALLINT num_cols;
1073  TDSCOLUMN **columns;
1074  TDS_INT row_size;
1075  TDS_INT ref_count;
1076  unsigned char *current_row;
1077  void (*row_free)(struct tds_result_info* result, unsigned char *row);
1078 
1079  TDS_SMALLINT rows_exist;
1080  /* TODO remove ?? used only in dblib */
1081  TDS_INT row_count;
1082  /* TODO remove ?? used only in dblib */
1083  TDS_TINYINT more_results;
1084  TDS_SMALLINT computeid;
1085  TDS_SMALLINT *bycolumns;
1086  TDS_SMALLINT by_cols;
1087 } TDSRESULTINFO;
1088 
1090 typedef enum _TDS_STATE
1091 {
1097 } TDS_STATE;
1098 
1099 #define TDS_DBG_LOGIN __FILE__, ((__LINE__ << 4) | 11)
1100 #define TDS_DBG_HEADER __FILE__, ((__LINE__ << 4) | 10)
1101 #define TDS_DBG_FUNC __FILE__, ((__LINE__ << 4) | 7)
1102 #define TDS_DBG_INFO2 __FILE__, ((__LINE__ << 4) | 6)
1103 #define TDS_DBG_INFO1 __FILE__, ((__LINE__ << 4) | 5)
1104 #define TDS_DBG_NETWORK __FILE__, ((__LINE__ << 4) | 4)
1105 #define TDS_DBG_WARN __FILE__, ((__LINE__ << 4) | 3)
1106 #define TDS_DBG_ERROR __FILE__, ((__LINE__ << 4) | 2)
1107 #define TDS_DBG_SEVERE __FILE__, ((__LINE__ << 4) | 1)
1108 
1109 #define TDS_DBGFLAG_FUNC 0x80
1110 #define TDS_DBGFLAG_INFO2 0x40
1111 #define TDS_DBGFLAG_INFO1 0x20
1112 #define TDS_DBGFLAG_NETWORK 0x10
1113 #define TDS_DBGFLAG_WARN 0x08
1114 #define TDS_DBGFLAG_ERROR 0x04
1115 #define TDS_DBGFLAG_SEVERE 0x02
1116 #define TDS_DBGFLAG_ALL 0xfff
1117 #define TDS_DBGFLAG_LOGIN 0x0800
1118 #define TDS_DBGFLAG_HEADER 0x0400
1119 #define TDS_DBGFLAG_PID 0x1000
1120 #define TDS_DBGFLAG_TIME 0x2000
1121 #define TDS_DBGFLAG_SOURCE 0x4000
1122 #define TDS_DBGFLAG_THREAD 0x8000
1123 
1124 #if 0
1125 
1130 enum TDS_DBG_LOG_STATE
1131 {
1132  TDS_DBG_LOGIN = (1 << 0)
1134  , TDS_DBG_API = (1 << 1)
1135  , TDS_DBG_ASYNC = (1 << 2)
1136  , TDS_DBG_DIAG = (1 << 3)
1137  , TDS_DBG_error = (1 << 4)
1138  /* TODO: ^^^^^ make upper case when old #defines (above) are removed */
1139  /* Log FreeTDS runtime/logic error occurs. */
1140  , TDS_DBG_PACKET = (1 << 5)
1141  , TDS_DBG_LIBTDS = (1 << 6)
1142  , TDS_DBG_CONFIG = (1 << 7)
1143  , TDS_DBG_DEFAULT = 0xFE
1144 };
1145 #endif
1146 
1147 typedef struct tds_result_info TDSCOMPUTEINFO;
1148 
1149 typedef TDSRESULTINFO TDSPARAMINFO;
1150 
1151 typedef struct tds_message
1152 {
1153  TDS_CHAR *server;
1154  TDS_CHAR *message;
1155  TDS_CHAR *proc_name;
1156  TDS_CHAR *sql_state;
1157  TDS_UINT msgno;
1158  TDS_INT line_number;
1159  /* -1 .. 255 */
1160  TDS_SMALLINT state;
1161  TDS_TINYINT priv_msg_type;
1162  TDS_TINYINT severity;
1163  /* for library-generated errors */
1164  int oserr;
1165 } TDSMESSAGE;
1166 
1167 typedef struct tds_upd_col
1168 {
1169  struct tds_upd_col *next;
1170  TDS_INT colnamelength;
1171  char * columnname;
1172 } TDSUPDCOL;
1173 
1174 typedef enum {
1175  TDS_CURSOR_STATE_UNACTIONED = 0 /* initial value */
1176  , TDS_CURSOR_STATE_REQUESTED = 1 /* called by ct_cursor */
1177  , TDS_CURSOR_STATE_SENT = 2 /* sent to server */
1178  , TDS_CURSOR_STATE_ACTIONED = 3 /* acknowledged by server */
1179 } TDS_CURSOR_STATE;
1180 
1181 typedef struct tds_cursor_status
1182 {
1183  TDS_CURSOR_STATE declare;
1184  TDS_CURSOR_STATE cursor_row;
1185  TDS_CURSOR_STATE open;
1186  TDS_CURSOR_STATE fetch;
1187  TDS_CURSOR_STATE close;
1188  TDS_CURSOR_STATE dealloc;
1190 
1191 typedef enum tds_cursor_operation
1192 {
1193  TDS_CURSOR_POSITION = 0,
1194  TDS_CURSOR_UPDATE = 1,
1195  TDS_CURSOR_DELETE = 2,
1196  TDS_CURSOR_INSERT = 4
1197 } TDS_CURSOR_OPERATION;
1198 
1199 typedef enum tds_cursor_fetch
1200 {
1201  TDS_CURSOR_FETCH_NEXT = 1,
1202  TDS_CURSOR_FETCH_PREV,
1203  TDS_CURSOR_FETCH_FIRST,
1204  TDS_CURSOR_FETCH_LAST,
1205  TDS_CURSOR_FETCH_ABSOLUTE,
1206  TDS_CURSOR_FETCH_RELATIVE
1207 } TDS_CURSOR_FETCH;
1208 
1212 typedef struct tds_cursor
1213 {
1214  struct tds_cursor *next;
1215  TDS_INT ref_count;
1216  TDS_TINYINT cursor_name_len;
1217  char *cursor_name;
1218  TDS_INT cursor_id;
1219  TDS_TINYINT options;
1220  TDS_TINYINT hasargs;
1221  TDS_USMALLINT query_len;
1222  char *query;
1223  /* TODO for updatable columns */
1224  /* TDS_TINYINT number_upd_cols; */
1225  /* TDSUPDCOL *cur_col_list; */
1226  TDS_INT cursor_rows;
1227  /* TDSPARAMINFO *params; */
1229  TDS_SMALLINT srv_status;
1230  TDSRESULTINFO *res_info;
1231  TDS_INT type, concurrency;
1232 } TDSCURSOR;
1233 
1237 typedef struct tds_env
1238 {
1239  int block_size;
1240  char *language;
1241  char *charset;
1242  char *database;
1243 } TDSENV;
1244 
1248 typedef struct tds_dynamic
1249 {
1250  struct tds_dynamic *next;
1256  char id[30];
1257  /* int dyn_state; */ /* TODO use it */
1259  TDS_INT num_id;
1276  char *query;
1277 } TDSDYNAMIC;
1278 
1279 typedef enum {
1280  TDS_MULTIPLE_QUERY,
1281  TDS_MULTIPLE_EXECUTE,
1282  TDS_MULTIPLE_RPC
1283 } TDS_MULTIPLE_TYPE;
1284 
1285 typedef struct tds_multiple
1286 {
1287  TDS_MULTIPLE_TYPE type;
1288  unsigned int flags;
1289 } TDSMULTIPLE;
1290 
1291 /* forward declaration */
1292 typedef struct tds_context TDSCONTEXT;
1293 typedef int (*err_handler_t) (const TDSCONTEXT *, TDSSOCKET *, TDSMESSAGE *);
1294 
1296 {
1297  TDSLOCALE *locale;
1298  void *parent;
1299  /* handlers */
1300  int (*msg_handler) (const TDSCONTEXT *, TDSSOCKET *, TDSMESSAGE *);
1301  int (*err_handler) (const TDSCONTEXT *, TDSSOCKET *, TDSMESSAGE *);
1302  int (*int_handler) (void *);
1303 };
1304 
1305 enum TDS_ICONV_ENTRY
1306 {
1307  client2ucs2
1308  , client2server_chardata
1309  , iso2server_metadata
1310  , initial_char_conv_count /* keep last */
1311 };
1312 
1313 typedef struct tds_authentication
1314 {
1315  TDS_UCHAR *packet;
1316  int packet_len;
1317  int (*free)(TDSSOCKET * tds, struct tds_authentication * auth);
1318  int (*handle_next)(TDSSOCKET * tds, struct tds_authentication * auth, size_t len);
1320 
1325 {
1326  TDS_SYS_SOCKET s;
1328  TDS_USMALLINT tds_version;
1329  TDS_UINT product_version;
1330  char *product_name;
1331 
1332  unsigned char capabilities[TDS_MAX_CAPABILITY];
1333  unsigned int broken_dates:1;
1334  unsigned int emul_little_endian:1;
1335  unsigned int use_iconv:1;
1336  unsigned int tds71rev1:1;
1337 
1338  unsigned char *in_buf;
1339  unsigned char *out_buf;
1340  unsigned int in_buf_max;
1341  unsigned in_pos;
1342  unsigned out_pos;
1343  unsigned in_len;
1345  unsigned char in_flag;
1346  unsigned char out_flag;
1347  void *parent;
1348 
1355  TDSRESULTINFO *res_info;
1356  TDS_INT num_comp_info;
1357  TDSCOMPUTEINFO **comp_info;
1358  TDSPARAMINFO *param_info;
1361  TDS_TINYINT has_status;
1362  TDS_INT ret_status;
1363  TDS_STATE state;
1364 
1365  volatile
1366  unsigned char in_cancel;
1368  TDS_INT8 rows_affected;
1369  TDS_INT query_timeout;
1370  TDSENV env;
1371 
1375  const TDSCONTEXT *tds_ctx;
1376  int char_conv_count;
1377  TDSICONV **char_convs;
1378 
1381  int spid;
1382  TDS_UCHAR collation[5];
1383  TDS_UCHAR tds9_transaction[8];
1384  void (*env_chg_func) (TDSSOCKET * tds, int type, char *oldval, char *newval);
1385  int internal_sp_called;
1386 
1387  void *tls_session;
1388  void *tls_credentials;
1389  TDSAUTHENTICATION *authentication;
1390  int option_value;
1391 };
1392 
1393 int tds_init_write_buf(TDSSOCKET * tds);
1394 void tds_free_result_info(TDSRESULTINFO * info);
1395 void tds_free_socket(TDSSOCKET * tds);
1396 void tds_free_connection(TDSCONNECTION * connection);
1397 void tds_free_all_results(TDSSOCKET * tds);
1398 void tds_free_results(TDSRESULTINFO * res_info);
1399 void tds_free_param_results(TDSPARAMINFO * param_info);
1400 void tds_free_param_result(TDSPARAMINFO * param_info);
1401 void tds_free_msg(TDSMESSAGE * message);
1402 void tds_cursor_deallocated(TDSSOCKET *tds, TDSCURSOR *cursor);
1403 void tds_release_cursor(TDSSOCKET *tds, TDSCURSOR *cursor);
1404 void tds_free_bcp_column_data(BCPCOLDATA * coldata);
1405 
1406 int tds_put_n(TDSSOCKET * tds, const void *buf, size_t n);
1407 int tds_put_string(TDSSOCKET * tds, const char *buf, int len);
1408 int tds_put_int(TDSSOCKET * tds, TDS_INT i);
1409 int tds_put_int8(TDSSOCKET * tds, TDS_INT8 i);
1410 int tds_put_smallint(TDSSOCKET * tds, TDS_SMALLINT si);
1412 #define tds_put_tinyint(tds, ti) tds_put_byte(tds,ti)
1413 int tds_put_byte(TDSSOCKET * tds, unsigned char c);
1414 TDSRESULTINFO *tds_alloc_results(int num_cols);
1415 TDSCOMPUTEINFO **tds_alloc_compute_results(TDSSOCKET * tds, int num_cols, int by_cols);
1416 TDSCONTEXT *tds_alloc_context(void * parent);
1417 void tds_free_context(TDSCONTEXT * locale);
1418 TDSSOCKET *tds_alloc_socket(TDSCONTEXT * context, int bufsize);
1419 
1420 /* config.c */
1421 int tds_default_port(int major, int minor);
1423 typedef void (*TDSCONFPARSE) (const char *option, const char *value, void *param);
1424 int tds_read_conf_section(FILE * in, const char *section, TDSCONFPARSE tds_conf_parse, void *parse_param);
1425 int tds_read_conf_file(TDSCONNECTION * connection, const char *server);
1426 void tds_parse_conf_section(const char *option, const char *value, void *param);
1428 void tds_fix_connection(TDSCONNECTION * connection);
1429 TDS_USMALLINT tds_config_verstr(const char *tdsver, TDSCONNECTION * connection);
1430 int tds_lookup_host(const char *servername, char *ip);
1431 int tds_set_interfaces_file_loc(const char *interfloc);
1432 extern const char STD_DATETIME_FMT[];
1433 int tds_config_boolean(const char *value);
1434 
1435 TDSLOCALE *tds_get_locale(void);
1436 int tds_alloc_row(TDSRESULTINFO * res_info);
1437 int tds_alloc_compute_row(TDSCOMPUTEINFO * res_info);
1438 BCPCOLDATA * tds_alloc_bcp_column_data(int column_size);
1439 unsigned char *tds7_crypt_pass(const unsigned char *clear_pass, size_t len, unsigned char *crypt_pass);
1440 TDSDYNAMIC *tds_lookup_dynamic(TDSSOCKET * tds, const char *id);
1441 /*@observer@*/ const char *tds_prtype(int token);
1442 int tds_get_varint_size(TDSSOCKET * tds, int datatype);
1443 int tds_get_cardinal_type(int datatype, int usertype);
1444 
1445 
1446 
1447 /* iconv.c */
1448 void tds_iconv_open(TDSSOCKET * tds, const char *charset);
1449 void tds_iconv_close(TDSSOCKET * tds);
1450 void tds_srv_charset_changed(TDSSOCKET * tds, const char *charset);
1451 void tds7_srv_charset_changed(TDSSOCKET * tds, int sql_collate, int lcid);
1452 int tds_iconv_alloc(TDSSOCKET * tds);
1453 void tds_iconv_free(TDSSOCKET * tds);
1454 TDSICONV *tds_iconv_from_collate(TDSSOCKET * tds, TDS_UCHAR collate[5]);
1455 
1456 /* threadsafe.c */
1457 char *tds_timestamp_str(char *str, int maxlen);
1458 struct tm *tds_localtime_r(const time_t *timep, struct tm *result);
1459 struct hostent *tds_gethostbyname_r(const char *servername, struct hostent *result, char *buffer, int buflen, int *h_errnop);
1460 struct hostent *tds_gethostbyaddr_r(const char *addr, int len, int type, struct hostent *result, char *buffer, int buflen,
1461  int *h_errnop);
1462 struct servent *tds_getservbyname_r(const char *name, const char *proto, struct servent *result, char *buffer, int buflen);
1463 #ifdef INADDR_NONE
1464 const char *tds_inet_ntoa_r(struct in_addr iaddr, char *ip, size_t len);
1465 #endif
1466 char *tds_get_homedir(void);
1467 
1468 /* mem.c */
1470 void tds_free_input_params(TDSDYNAMIC * dyn);
1471 void tds_free_dynamic(TDSSOCKET * tds, TDSDYNAMIC * dyn);
1472 TDSSOCKET *tds_realloc_socket(TDSSOCKET * tds, size_t bufsize);
1473 char *tds_alloc_client_sqlstate(int msgno);
1474 char *tds_alloc_lookup_sqlstate(TDSSOCKET * tds, int msgno);
1475 TDSLOGIN *tds_alloc_login(void);
1476 TDSDYNAMIC *tds_alloc_dynamic(TDSSOCKET * tds, const char *id);
1477 void tds_free_login(TDSLOGIN * login);
1479 TDSLOCALE *tds_alloc_locale(void);
1480 void *tds_alloc_param_data(TDSCOLUMN * curparam);
1481 void tds_free_locale(TDSLOCALE * locale);
1482 TDSCURSOR * tds_alloc_cursor(TDSSOCKET * tds, const char *name, TDS_INT namelen, const char *query, TDS_INT querylen);
1483 void tds_free_row(TDSRESULTINFO * res_info, unsigned char *row);
1484 
1485 /* login.c */
1486 void tds_set_packet(TDSLOGIN * tds_login, int packet_size);
1487 void tds_set_port(TDSLOGIN * tds_login, int port);
1488 void tds_set_passwd(TDSLOGIN * tds_login, const char *password);
1489 void tds_set_bulk(TDSLOGIN * tds_login, TDS_TINYINT enabled);
1490 void tds_set_user(TDSLOGIN * tds_login, const char *username);
1491 void tds_set_app(TDSLOGIN * tds_login, const char *application);
1492 void tds_set_host(TDSLOGIN * tds_login, const char *hostname);
1493 void tds_set_library(TDSLOGIN * tds_login, const char *library);
1494 void tds_set_server(TDSLOGIN * tds_login, const char *server);
1495 void tds_set_client_charset(TDSLOGIN * tds_login, const char *charset);
1496 void tds_set_language(TDSLOGIN * tds_login, const char *language);
1497 void tds_set_database_name(TDSLOGIN * tds_login, const char *dbname);
1498 void tds_set_version(TDSLOGIN * tds_login, TDS_TINYINT major_ver, TDS_TINYINT minor_ver);
1499 void tds_set_capabilities(TDSLOGIN * tds_login, unsigned char *capabilities, int size);
1500 int tds_connect_and_login(TDSSOCKET * tds, TDSCONNECTION * connection);
1501 
1502 /* query.c */
1503 int tds_submit_query(TDSSOCKET * tds, const char *query);
1504 int tds_submit_query_params(TDSSOCKET * tds, const char *query, TDSPARAMINFO * params);
1505 int tds_submit_queryf(TDSSOCKET * tds, const char *queryf, ...);
1506 int tds_submit_prepare(TDSSOCKET * tds, const char *query, const char *id, TDSDYNAMIC ** dyn_out, TDSPARAMINFO * params);
1507 int tds_submit_execdirect(TDSSOCKET * tds, const char *query, TDSPARAMINFO * params);
1508 int tds8_submit_prepexec(TDSSOCKET * tds, const char *query, const char *id, TDSDYNAMIC ** dyn_out, TDSPARAMINFO * params);
1509 int tds_submit_execute(TDSSOCKET * tds, TDSDYNAMIC * dyn);
1510 int tds_send_cancel(TDSSOCKET * tds);
1511 const char *tds_next_placeholder(const char *start);
1512 int tds_count_placeholders(const char *query);
1513 int tds_needs_unprepare(TDSSOCKET * tds, TDSDYNAMIC * dyn);
1514 int tds_submit_unprepare(TDSSOCKET * tds, TDSDYNAMIC * dyn);
1515 int tds_submit_rpc(TDSSOCKET * tds, const char *rpc_name, TDSPARAMINFO * params);
1516 int tds_submit_optioncmd(TDSSOCKET * tds, TDS_OPTION_CMD command, TDS_OPTION option, TDS_OPTION_ARG *param, TDS_INT param_size);
1517 int tds_quote_id(TDSSOCKET * tds, char *buffer, const char *id, int idlen);
1518 int tds_quote_string(TDSSOCKET * tds, char *buffer, const char *str, int len);
1519 const char *tds_skip_quoted(const char *s);
1520 
1521 int tds_cursor_declare(TDSSOCKET * tds, TDSCURSOR * cursor, TDSPARAMINFO *params, int *send);
1522 int tds_cursor_setrows(TDSSOCKET * tds, TDSCURSOR * cursor, int *send);
1523 int tds_cursor_open(TDSSOCKET * tds, TDSCURSOR * cursor, TDSPARAMINFO *params, int *send);
1524 int tds_cursor_fetch(TDSSOCKET * tds, TDSCURSOR * cursor, TDS_CURSOR_FETCH fetch_type, TDS_INT i_row);
1525 int tds_cursor_get_cursor_info(TDSSOCKET * tds, TDSCURSOR * cursor, TDS_UINT * row_number, TDS_UINT * row_count);
1526 int tds_cursor_close(TDSSOCKET * tds, TDSCURSOR * cursor);
1527 int tds_cursor_dealloc(TDSSOCKET * tds, TDSCURSOR * cursor);
1528 int tds_cursor_update(TDSSOCKET * tds, TDSCURSOR * cursor, TDS_CURSOR_OPERATION op, TDS_INT i_row, TDSPARAMINFO * params);
1529 int tds_cursor_setname(TDSSOCKET * tds, TDSCURSOR * cursor);
1530 
1531 int tds_multiple_init(TDSSOCKET *tds, TDSMULTIPLE *multiple, TDS_MULTIPLE_TYPE type);
1532 int tds_multiple_done(TDSSOCKET *tds, TDSMULTIPLE *multiple);
1533 int tds_multiple_query(TDSSOCKET *tds, TDSMULTIPLE *multiple, const char *query, TDSPARAMINFO * params);
1534 int tds_multiple_execute(TDSSOCKET *tds, TDSMULTIPLE *multiple, TDSDYNAMIC * dyn);
1535 
1536 /* token.c */
1537 int tds_process_cancel(TDSSOCKET * tds);
1538 #ifdef WORDS_BIGENDIAN
1539 void tds_swap_datatype(int coltype, unsigned char *buf);
1540 #endif
1541 void tds_swap_numeric(TDS_NUMERIC *num);
1542 int tds_get_token_size(int marker);
1545 int tds5_send_optioncmd(TDSSOCKET * tds, TDS_OPTION_CMD tds_command, TDS_OPTION tds_option, TDS_OPTION_ARG * tds_argument,
1546  TDS_INT * tds_argsize);
1547 int tds_process_tokens(TDSSOCKET * tds, /*@out@*/ TDS_INT * result_type, /*@out@*/ int *done_flags, unsigned flag);
1548 
1549 /* data.c */
1550 void tds_set_param_type(TDSSOCKET * tds, TDSCOLUMN * curcol, TDS_SERVER_TYPE type);
1551 void tds_set_column_type(TDSSOCKET * tds, TDSCOLUMN * curcol, int type);
1552 TDS_INT tds_data_get_info(TDSSOCKET *tds, TDSCOLUMN *col);
1553 
1554 
1555 /* tds_convert.c */
1556 TDS_INT tds_datecrack(TDS_INT datetype, const void *di, TDSDATEREC * dr);
1557 int tds_get_conversion_type(int srctype, int colsize);
1558 extern const char tds_hex_digits[];
1559 
1560 /* write.c */
1561 int tds_flush_packet(TDSSOCKET * tds);
1562 int tds_put_buf(TDSSOCKET * tds, const unsigned char *buf, int dsize, int ssize);
1563 
1564 /* read.c */
1565 unsigned char tds_get_byte(TDSSOCKET * tds);
1566 void tds_unget_byte(TDSSOCKET * tds);
1567 unsigned char tds_peek(TDSSOCKET * tds);
1568 TDS_SMALLINT tds_get_smallint(TDSSOCKET * tds);
1569 TDS_INT tds_get_int(TDSSOCKET * tds);
1570 TDS_INT8 tds_get_int8(TDSSOCKET * tds);
1571 int tds_get_string(TDSSOCKET * tds, int string_len, char *dest, size_t dest_size);
1572 int tds_get_char_data(TDSSOCKET * tds, char *dest, size_t wire_size, TDSCOLUMN * curcol);
1573 void *tds_get_n(TDSSOCKET * tds, /*@out@*/ /*@null@*/ void *dest, int n);
1574 int tds_get_size_by_type(int servertype);
1575 
1576 
1577 /* util.c */
1578 int tdserror (const TDSCONTEXT * tds_ctx, TDSSOCKET * tds, int msgno, int errnum);
1579 TDS_STATE tds_set_state(TDSSOCKET * tds, TDS_STATE state);
1580 void tds_set_parent(TDSSOCKET * tds, void *the_parent);
1581 int tds_swap_bytes(unsigned char *buf, int bytes);
1582 int tds_version(TDSSOCKET * tds_socket, char *pversion_string);
1583 unsigned int tds_gettime_ms(void);
1584 int tds_get_req_capability(TDSSOCKET * tds, int cap);
1585 
1586 /* log.c */
1587 void tdsdump_off(void);
1588 void tdsdump_on(void);
1589 int tdsdump_isopen(void);
1590 #if defined(__GNUC__) && __GNUC__ >= 4 && !defined(__MINGW32__)
1591 #pragma GCC visibility pop
1592 #endif
1593 int tdsdump_open(const char *filename);
1594 #if defined(__GNUC__) && __GNUC__ >= 4 && !defined(__MINGW32__)
1595 #pragma GCC visibility push(hidden)
1596 #endif
1597 void tdsdump_close(void);
1598 void tdsdump_dump_buf(const char* file, unsigned int level_line, const char *msg, const void *buf, size_t length);
1599 void tdsdump_col(const TDSCOLUMN *col);
1600 #undef tdsdump_log
1601 void tdsdump_log(const char* file, unsigned int level_line, const char *fmt, ...)
1602 #if defined(__GNUC__) && __GNUC__ >= 2
1603  __attribute__ ((__format__ (__printf__, 3, 4)))
1604 #endif
1605 ;
1606 #define tdsdump_log if (TDS_UNLIKELY(tds_write_dump)) tdsdump_log
1607 
1608 extern int tds_write_dump;
1609 extern int tds_debug_flags;
1610 extern int tds_g_append_mode;
1611 
1612 /* net.c */
1613 int tds_lastpacket(TDSSOCKET * tds);
1614 TDSERRNO tds_open_socket(TDSSOCKET * tds, const char *ip_addr, unsigned int port, int timeout, int *p_oserr);
1615 int tds_close_socket(TDSSOCKET * tds);
1616 int tds_read_packet(TDSSOCKET * tds);
1617 int tds_write_packet(TDSSOCKET * tds, unsigned char final);
1618 int tds7_get_instance_ports(FILE *output, const char *ip_addr);
1619 int tds7_get_instance_port(const char *ip_addr, const char *instance);
1620 int tds_ssl_init(TDSSOCKET *tds);
1621 void tds_ssl_deinit(TDSSOCKET *tds);
1622 const char *tds_prwsaerror(int erc);
1623 
1624 
1625 
1626 /* vstrbuild.c */
1627 int tds_vstrbuild(char *buffer, int buflen, int *resultlen, char *text, int textlen, const char *formats, int formatlen,
1628  va_list ap);
1629 
1630 /* numeric.c */
1631 char *tds_money_to_string(const TDS_MONEY * money, char *s);
1632 TDS_INT tds_numeric_to_string(const TDS_NUMERIC * numeric, char *s);
1633 TDS_INT tds_numeric_change_prec_scale(TDS_NUMERIC * numeric, unsigned char new_prec, unsigned char new_scale);
1634 
1635 /* getmac.c */
1636 void tds_getmac(TDS_SYS_SOCKET s, unsigned char mac[6]);
1637 
1638 #ifndef HAVE_SSPI
1640 TDSAUTHENTICATION * tds_gss_get_auth(TDSSOCKET * tds);
1641 #else
1642 TDSAUTHENTICATION * tds_sspi_get_auth(TDSSOCKET * tds);
1643 #endif
1644 
1645 /* bulk.c */
1646 
1649 {
1650  TDS_BCP_IN = 1,
1651  TDS_BCP_OUT = 2,
1652  TDS_BCP_QUERYOUT = 3
1653 };
1654 
1655 typedef struct tds_bcpinfo
1656 {
1657  const char *hint;
1658  void *parent;
1659  TDS_CHAR *tablename;
1660  TDS_CHAR *insert_stmt;
1661  TDS_INT direction;
1662  TDS_INT identity_insert_on;
1663  TDS_INT xfer_init;
1664  TDS_INT var_cols;
1665  TDS_INT bind_count;
1666  TDSRESULTINFO *bindinfo;
1667 } TDSBCPINFO;
1668 
1669 int tds_bcp_init(TDSSOCKET *tds, TDSBCPINFO *bcpinfo);
1670 typedef int (*tds_bcp_get_col_data) (TDSBCPINFO *bulk, TDSCOLUMN *bcpcol, int offset);
1671 typedef void (*tds_bcp_null_error) (TDSBCPINFO *bulk, int index, int offset);
1672 int tds_bcp_send_record(TDSSOCKET *tds, TDSBCPINFO *bcpinfo, tds_bcp_get_col_data get_col_data, tds_bcp_null_error null_error, int offset);
1673 int tds_bcp_done(TDSSOCKET *tds, int *rows_copied);
1674 int tds_bcp_start(TDSSOCKET *tds, TDSBCPINFO *bcpinfo);
1675 int tds_bcp_start_copy_in(TDSSOCKET *tds, TDSBCPINFO *bcpinfo);
1676 
1677 int tds_writetext_start(TDSSOCKET *tds, const char *objname, const char *textptr, const char *timestamp, int with_log, TDS_UINT size);
1678 int tds_writetext_continue(TDSSOCKET *tds, const TDS_UCHAR *text, TDS_UINT size);
1679 int tds_writetext_end(TDSSOCKET *tds);
1680 
1681 
1682 #define IS_TDS42(x) (x->tds_version==0x402)
1683 #define IS_TDS46(x) (x->tds_version==0x406)
1684 #define IS_TDS50(x) (x->tds_version==0x500)
1685 #define IS_TDS70(x) (x->tds_version==0x700)
1686 #define IS_TDS71(x) (x->tds_version==0x701)
1687 #define IS_TDS72(x) (x->tds_version==0x702)
1688 
1689 #define IS_TDS7_PLUS(x) ((x)->tds_version>=0x700)
1690 #define IS_TDS71_PLUS(x) ((x)->tds_version>=0x701)
1691 #define IS_TDS72_PLUS(x) ((x)->tds_version>=0x702)
1692 
1693 #define TDS_MAJOR(x) ((x)->tds_version >> 8)
1694 #define TDS_MINOR(x) ((x)->tds_version & 0xff)
1695 
1696 #define IS_TDSDEAD(x) (((x) == NULL) || TDS_IS_SOCKET_INVALID((x)->s))
1697 
1699 #define TDS_IS_SYBASE(x) (!(x->product_version & 0x80000000u))
1700 
1701 #define TDS_IS_MSSQL(x) ((x->product_version & 0x80000000u)!=0)
1702 
1706 #define TDS_MS_VER(maj,min,x) (0x80000000u|((maj)<<24)|((min)<<16)|(x))
1707 
1708 /* TODO test if not similar to ms one*/
1710 #define TDS_SYB_VER(maj,min,x) (((maj)<<24)|((min)<<16)|(x)<<8)
1711 
1712 #ifdef __cplusplus
1713 #if 0
1714 {
1715 #endif
1716 }
1717 #endif
1718 
1719 #if defined(__GNUC__) && __GNUC__ >= 4 && !defined(__MINGW32__)
1720 #pragma GCC visibility pop
1721 #endif
1722 
1723 #define TDS_PUT_INT(tds,v) tds_put_int((tds), ((TDS_INT)(v)))
1724 #define TDS_PUT_SMALLINT(tds,v) tds_put_smallint((tds), ((TDS_SMALLINT)(v)))
1725 #define TDS_PUT_BYTE(tds,v) tds_put_byte((tds), ((unsigned char)(v)))
1726 
1727 #endif /* _tds_h_ */